Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

2-axis logarithmic charts

Posted by Chris W on June 20, 2001 10:55 AM

I'm trying to make a chart that has two lines, and two logarithmic Y axis scales (one on the right and one on the left). There is a custom chart that does this for linear scales, but I can't make the scales log. Any idea where I can get a custom chart format for this?

-=Chris

Re: 2-axis logarithmic charts

Posted by Ben Osborne on June 20, 2001 1:08 PM

Chart both series on the same logarithmic chart, then select one of the lines, right-click on it and select Format Data Series. On the Axis tab, under "Plot Series On:", select Secondary Axis. That will create a second Y axis on the right. Select that axis, right-click on it, and select Format Axis. On the Scale tab, click on "Logarithmic Scale." That should do it.

-Ben

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.