Using scale to explode a tight data set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike - 25 Oct 2006 12:58 GMT

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?

Reply to this Message

David Biddulph - 25 Oct 2006 14:12 GMT

Format Axis/ Scale

Signature

David Biddulph

>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?

Reply to this Message

mike - 25 Oct 2006 14:27 GMT

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

> Format Axis/ Scale
> >I have a very tight data set and need to seperate the data points, i guess
[quoted text clipped - 3 lines]
> > data
> > points so that they are not so tight when ploted?

Reply to this Message

Jon Peltier - 25 Oct 2006 23:20 GMT

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
_______

Reply to this Message