JakeHarrison92
New Member
- Joined
- Oct 18, 2016
- Messages
- 2
Complete Excel novice here..
I have five years of data from three companies (+totals) that I am displaying in a bar chart. For 2016, as well as the actual figures, I would like to show the annualised figures (an estimate of what could be made for the rest of the year) but as a stacked bar, i.e. as a different colour, extended to the actual figure.
So I think I want the chart to be a mixture of bar and stacked, but I can't figure out how to set up the data. Below is what I have so far - any help would be massively appreciated!
I have five years of data from three companies (+totals) that I am displaying in a bar chart. For 2016, as well as the actual figures, I would like to show the annualised figures (an estimate of what could be made for the rest of the year) but as a stacked bar, i.e. as a different colour, extended to the actual figure.
So I think I want the chart to be a mixture of bar and stacked, but I can't figure out how to set up the data. Below is what I have so far - any help would be massively appreciated!
