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?

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?

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?

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?