You can add a tertiary axis (which I don't particularly like):
http://peltiertech.com/Excel/Charts/TertiaryAxis.html
or you could make a panel chart, in which the chart has three separate
panels, one for each axis scale range:
http://peltiertech.com/Excel/Charts/StackedCharts.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"coastal" wrote in message
...
I have three different columns that I want on one chart to show that they
all
follow the same trend. Is there a way to have all on a line chart but so
that the smallest numbers (last column) don't disappear into the x-axis
line?
Basically want three lines but all in the middle of the chart showing
spikes
& lows.
ex:
client A B C
c1 1000 100 1.0
c2 2400 200 2.0
c3 1500 150 1.5
c4 3000 300 3.0
--
--coastal