I'm trying to create a chart (excel 2007) with 2 different column types on the same graph.
I need to compare a planned monthly activity figure with an actual monthly activity figure.
The actual monthly activity figure is made of 2 figures (called first and follow ups) and i would like to plot these 2 series as one column, next to the planned activity series as a seperate column.
I also have a variance figure plotted on a secondary axis - which is a percentage.
I can't work out how to get the columns as i want. Any help would be appreciated. I've done a really quick drawing in paint and attached it to better explain what i'm trying to do. I have everything apart from the combined first and follow up bar. I can't seem to get that working.
Thanks in advance
Edit: As i wrote this i had a thought. All i really need to know is how to get two seperate sets of stacked columns next to each other.
Bookmarks