View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how to make an XYY graph

Right click one series, choose Format, and on the Axis tab (Excel up to
2003) or the first tab (2007) choose Secondary.

Using two sets of axes can be confusing, and can give rise to false
conclusions about the data. For example, there is no significance to where
two lines on different scales intersect. Format carefully to reduce
confusion.

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


"Jeff Lynum" <Jeff wrote in message
...
I want to compare to sets of numbers like temperature and relative humidity
for given times. I need each y-axis to have a different label and set of
numbers. How do I do that?