More than one vertical axis?

  • Thread starter Thread starter Dr. Darwin
  • Start date Start date
D

Dr. Darwin

Hello,
I am plotting year on the x-axis and trying to plot
interest rate of the left vertical axis and dollars on the
right vertical axis of a line graph.
How do I set up a two (left and right) vertical axis chart?

Please let me know,
Thanks for your time
 
Create a chart with both series (rates and dollars).
Right-click on one of the series
Choose Format Data Series
 
Plot both the series (rate and $). Then, on the chart, double-click
whichever you want on the secondary (right) axis and in the resulting
dialog box, from the Axes tab, select the 'Secondary' option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks for trying to respond to my message Debra and
Tushar, but unfortunatly I cannot read your reply because
I am getting :
"Message unavailable" for both of the replys.
If you may please repost your responses so that I may read
them.
Thanks again
 
I assume you found the answers through the MS CDO. If not, check the
google.com archives of the XL newsgroups. Also, consider using a
newsreader program. For a tutorial, see the Other Tutorials/Outlook
Express & Newsgroups page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top