Using scale to explode a tight data set
 

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?

Using scale to explode a tight data set
 

Format Axis/ Scale
--
David Biddulph

"mike" wrote in message
...
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?

Using scale to explode a tight data set
 

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
"David Biddulph" wrote:

Format Axis/ Scale
--
David Biddulph

"mike" wrote in message
...
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?

Using scale to explode a tight data set
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mike" wrote in message
...
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?