MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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

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

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