BOF Posted November 4, 2016 Author Moderator Share Posted November 4, 2016 Just now, CardiffGreens said: When you click on your bars, they'll all be selected. Single click again on the one you want to change and it'll only select that one - the right click menu will then have "Format data point" as the bottom option - allowing you to change that bar's colour in the fill menu (and if you leave the "format data point" option open, you can select another individual bar to change that one as well - without having to close the option menu and reopen it). Actually yeah that does work I take it the automatic option is a non-starter. Link to comment Share on other sites More sharing options...
CardiffGreens Posted November 4, 2016 Share Posted November 4, 2016 You could fudge it with 2 columns of data - 1 for "non televised" attendance, and the other for "televised" attendance (so game 1 on TV would have 0 in "non televised" and 35000 in televised, game 2 not on TV would have 35000 in "non-televised" and 0 in "televised") , and have the graph stack the two values on top of each other for each game. 2 Link to comment Share on other sites More sharing options...
BOF Posted November 4, 2016 Author Moderator Share Posted November 4, 2016 Just now, CardiffGreens said: You could fudge it with 2 columns of data - 1 for "non televised" attendance, and the other for "televised" attendance (so game 1 on TV would have 0 in "non televised" and 35000 in televised, game 2 not on TV would have 35000 in "non-televised" and 0 in "televised") , and have the graph stack the two values on top of each other for each game. This is true. Good thinking Batfink. I can see you've been problem-solving excel charts for a while 1 Link to comment Share on other sites More sharing options...
BOF Posted November 4, 2016 Author Moderator Share Posted November 4, 2016 Automated innit Thanks @CardiffGreens ! 1 Link to comment Share on other sites More sharing options...
Recommended Posts