Using scale to explode a tight data set

[mike]

I have a very tight data set and need to seperate the data points, i guess by
changing the scale of the Y axis. I have 3 variables I charting with the
delta between each monthly point ~300K. How can I seperate/explode the data
points so that they are not so tight when ploted?

 

[David Biddulph]

Format Axis/ Scale

 

[mike]

Thanks David, I know where to make the change within Excel, but no matter
what y axis scale I entered I could not seperate the data set. I finally
decided to use a "stacked chart" format, which seperated the data, but causes
the Y axis to be mal-conformed to each data point. I removed the Y axis from
the chart. Seems like there is a better answer but I need to move forward.
thanks,
Mike

 

[Jon Peltier]

Your description isn't clear. Do you have three series, each with widely
varying values? I'd suggest making three charts. There's no value in
combining data into a single chart if you can't read the data.

Here's how to do this in a single chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html

- Jon