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

Chart Questions

Posted by G Spedema on June 28, 2001 4:25 AM

I am having problems getting the type of chart that I'd like. I need to plot 2 sets of data with different scales on the horizontal axis so that they "overlap". I have 2 sets of data, with height being on the vertical axis, and weight & cost on the horizontal. Is there any way that I can plot these 2 sets so they overlap, and display their relative scales, while allowing the display of overlapping graphs?

Secondary value axis

Posted by Eric on June 28, 2001 8:00 AM

Hi,
Excel does not allow two horizontal (X) axes, however, Excel does allow two Y (vertical) axes- use help (or clippy) and search for "second axis" for step by step instructions. You'd have to plot your data "Sideways" as compared to your description of what you want to plot though- hope that helps.

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.