software

Hi
I have 3 series of sales data I need to plot - actual, max budget amp; 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 quot;stackedquot; 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

Try one of the links on this page:

peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

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