Combining 2 different types of bar graph

G

Guest

Hi
I have 3 series of sales data I need to plot - actual, max budget & min
budget - for 12 months.
With the months being the x axis, I need the graph to be a standard bar
chart, with the colums side by side for each month (clustered column).
However, for the 2 bdget columns I need them to be of the "stacked" column
type - so that when the graph is presented we can see exactly how the actual
column each month compares to both budget figures.
I've tried changing the chart type for each of the series, but it seems to
change all 3 series each time. I could easily combine a line graph with the
stacked columns, but for some reason I can't combine stacked columns and
clustered columns.
I hope I've explained this well!!
Thanks in advance
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMBINING TWO DIFFERENT CHARTS 1
Stacked Bar Graph 1
How do I combine stacked and clustered chart types? 2
Stacked bar chart, Excel 2007 3
stacked column graph adjacent to a regular column graph 0
2 stacked, one discrete 1
Best way to show this on a graph? 3
Multiple Series of Series in Stacked Column chart? 2

Top