If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining 2 different types of bar graph
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 |
#2
|
|||
|
|||
Combining 2 different types of bar graph
Try one of the links on this page:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dave" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graph Help- 12 month graph, but only want months that have passed | coal_miner | Charts and Charting | 4 | June 3rd, 2005 03:03 PM |
Line Graph Data Recognition | Nat | Charts and Charting | 2 | April 30th, 2005 02:07 PM |
Pivot graph | Ludavhen | Worksheet Functions | 3 | August 25th, 2004 12:20 AM |
Excdel graph | Pat | Worksheet Functions | 0 | August 21st, 2004 07:14 PM |
Dynamically control how many lines on a graph? | Keith R | Charts and Charting | 2 | October 22nd, 2003 04:19 PM |