Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y axis
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 axiss to be inverted. How do i manually select which values got on which axis? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y 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 "Samy" wrote in message ... 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 axiss to be inverted. How do i manually select which values got on which axis? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y axis
Also, when you set up your next chart, put the X values in the column to the
left of the Y values. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Shane Devenshire" wrote in message ... 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 "Samy" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y axis
Hey Shane, Exactly right, thanks heaps.
"Shane Devenshire" wrote: 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 "Samy" wrote in message ... 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 axiss to be inverted. How do i manually select which values got on which axis? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y axis
Regarding this part of your tip:
So after you have created the chart you need to use 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. "Andy Pope" wrote: Hi, Unfortunately Excel tries to help by ordering the selected range. So with data in A2:B6, and X values in column B if you try this selection, $B$2:$B$6,$A$2:$A$6 Excel converts it to $A$2:$B$6 and then takes the first column as the x values. So after you have created the chart you need to use Chart Tools Design Data Select Data. In this dialog Edit the series and swap the x and y values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Samy" wrote in message ... 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 axiss to be inverted. How do i manually select which values got on which axis? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
x and y axis
That's Excel 2007. It's easier in 2002:
Chart menu Source Data Series tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "am_81" wrote in message ... Regarding this part of your tip: So after you have created the chart you need to use 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. "Andy Pope" wrote: Hi, Unfortunately Excel tries to help by ordering the selected range. So with data in A2:B6, and X values in column B if you try this selection, $B$2:$B$6,$A$2:$A$6 Excel converts it to $A$2:$B$6 and then takes the first column as the x values. So after you have created the chart you need to use Chart Tools Design Data Select Data. In this dialog Edit the series and swap the x and y values. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Samy" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |