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 help

Posted by Jay on October 03, 2001 5:47 PM

I am trying to make a graph with price on one axis and quantity on the other. I can't get excel to let me choose values for both axes, it always wants to make one axis based on the location of the chart on the spreadsheet. Please let me know how to make a chart that can show a relationship between two generated sets of data.

Start the chart wizard and select X-Y graph as your option

Posted by Eric on October 03, 2001 6:07 PM

You can then go to the series tab on the second step in the wizard and use the X and Y input boxes to select the two ranges you want.
HTH

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.