View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?