I have a spreadsheet that tracks student performance before a course and after a course split over a number of different subjects. The spreadsheet takes the subjects from elsewhere and then puts them across the top columns of a new tab. in the 2 rows below it has the score out of 10 before the course and a score out of ten after the course for each subject.
The issue is that the number of subjects changes.
I've set up a bar chart that nicely shows the before and after for each subject but when it reaches a column that has no subject heading - and by definition no scores - it of course still puts the blank data in the chart.
I can change the range of cells that the chart draws upon but I was hoping for a solution where the chart would know not to show any bars for blank columns. Otherwise I have to manually adjust each time the number of subjects changes.
Be grateful for any thoughts!
Thanks in anticipation...
Ian
Bookmarks