Stacked Charts w/ Vertical Separation

[Stacey]

I have read Jon Peltier's 'tutorial
(http://peltiertech.com/Excel/Charts/StackedCharts.html) regardin
*-stacked charts with vertical separation-* but I still have som
questions regarding this:

1)The values of the bars are appearing in percentages, not in the unit
I specified. My numbers are large, so I set the scale to a maximum o
150 (with 50 being the major spacing) but on the graph, the max appear
at 1.5 and all of my stacked columns end exactly at 1.0. This is how
know that the columns are appearing as percentages, and not the actua
values. How do I change this?

2)The tutorial only shows you how to make stacked charts all with th
same scales. How can I make stacked charts with different scales (sam
units)? If it is not possible to make stacked charts in the sam
spreadsheet like in Peltier's tutorial, how can I achieve the sam
look?

Thanks in advanc

 

[Barb Reinhardt]

I bet you've chosen the 100% stacked column for your chart type. Go to
your chart and change it to just a stacked column.