View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Additional secondary axis scales

I usually prefer to make a panel chart, with each series in its own panel.
It may take a bit more space, but it eliminates any confusion that multiple
axes produces. Here is a protocol for making a panel chart:

http://peltiertech.com/Excel/ChartsH...venScales.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Russ" wrote in message
...
I'm trying to chart multiple data on a daily basis. I have the date,
sewer
flow rate, rainfall and total population. My primary X-axis is the date,
my
primary Y-axis is flow rate, and my secondary Y-axis is the rain fall. I
would like to add another secondary axis scale to show the total
population.
Does any one know how to do this in Excel 2003?

Thanks,

Russ