Forum Discussion
Column Graph which excludes blank values
Column charts allow you to set a 100% overlap which will sort the spacing. 100% for the gaps might also be appropriate. You may also be able to choose a stacked chart, but one in which 3 series return 0. I am not that keen of Pivot tables; It often seems that the time saved building it is lost in formatting and forgetting to refresh it.
A bar chart is another possibility and has the benefit of being more compact for this type of data.
Column charts allow you to set a 100% overlap which will sort the spacing. 100% for the gaps might also be appropriate. You may also be able to choose a stacked chart, but one in which 3 series return 0. I am not that keen of Pivot tables; It often seems that the time saved building it is lost in formatting and forgetting to refresh it.
A bar chart is another possibility and has the benefit of being more compact for this type of data.
I also added a couple of other rows to the table for the date and the year - now battling with trying to get scroll bars and sliders to work!