x and y axis

  • Thread starter Thread starter Samy
  • Start date Start date
S

Samy

Hi, using Excel 2007 i am creating a line chart using price and quantity
data. When creating chart excel default values to x and y axis (X - price and
y - Quantity), However i require these axis’s to be inverted.

How do i manually select which values got on which axis?
 
Hi Samy,

It sounds like this is not a line chart but an XY-Scatter?

Here are a number of ways to do this:
1. You can select the series on the chart and edit the Series formula. For
example in the formula below:
=SERIES(Sheet1!$D$4,Sheet1!$C$5:$C$15,Sheet1!$D$5:$D$15,1)
You would swap the C5:C15 and D5:D15 references
2. You can choose ChartTools, Design, Select Data, Edit and reselect the
two ranges
3. You can select the series on the chart and then drag the border of the
blue highlight down one row and over to the other column, then drag the
purple highlight where the first range is, and then move the blue border up
one row to highlight the second range.

Cheers,
Shane Devenshire
 
Also, when you set up your next chart, put the X values in the column to the
left of the Y values.

- Jon
 
Hey Shane, Exactly right, thanks heaps.

Shane Devenshire said:
Hi Samy,

It sounds like this is not a line chart but an XY-Scatter?

Here are a number of ways to do this:
1. You can select the series on the chart and edit the Series formula. For
example in the formula below:
=SERIES(Sheet1!$D$4,Sheet1!$C$5:$C$15,Sheet1!$D$5:$D$15,1)
You would swap the C5:C15 and D5:D15 references
2. You can choose ChartTools, Design, Select Data, Edit and reselect the
two ranges
3. You can select the series on the chart and then drag the border of the
blue highlight down one row and over to the other column, then drag the
purple highlight where the first range is, and then move the blue border up
one row to highlight the second range.

Cheers,
Shane Devenshire
Click to expand...
 
Regarding this part of your tip:
Chart Tools > Design > Data > Select Data.
In this dialog Edit the series and swap the x and y values.

What version of Excel does this work for? I am using Excel XP and trying to
do the same thing as the original poster, but dont see any of these options.

Thanks.
 
That's Excel 2007. It's easier in 2002:

Chart menu > Source Data > Series tab.

- Jon
 
Back
Top