| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create a second "y" axis on the right?
|
|
#2
|
|||
|
|||
|
Derrick,
Create a simple line chart as an example with the following data: Ser1 Ser2 a 1 4 b 2 3 c 3 4 In the clart plot area, double-click on the series called "Ser2". It should be the higher line of the two series. In the Format Data Series dialog box, go to the Axis tab. Choose the option "Plot series on: Secondary axis". ---- Regards, John Mansfield http://www.pdbook.com "Derrick" wrote: |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a second "y" axis on the right?
This works great in Excel 1997-03, but how do you do this in Excel 2007? Lost_in_Houston "John Mansfield" wrote: Derrick, Create a simple line chart as an example with the following data: Ser1 Ser2 a 1 4 b 2 3 c 3 4 In the clart plot area, double-click on the series called "Ser2". It should be the higher line of the two series. In the Format Data Series dialog box, go to the Axis tab. Choose the option "Plot series on: Secondary axis". ---- Regards, John Mansfield http://www.pdbook.com "Derrick" wrote: |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a second "y" axis on the right?
Hi,
The principal is the same just the UI is different. Create the chart with the 2 series. Select the series called "Ser2". On the Layout or Format tab use the Format Selection within the Current Selection group. On the Series Option tab select Secondary axis. Cheers Andy Lost_in_Houston wrote: This works great in Excel 1997-03, but how do you do this in Excel 2007? Lost_in_Houston "John Mansfield" wrote: Derrick, Create a simple line chart as an example with the following data: Ser1 Ser2 a 1 4 b 2 3 c 3 4 In the clart plot area, double-click on the series called "Ser2". It should be the higher line of the two series. In the Format Data Series dialog box, go to the Axis tab. Choose the option "Plot series on: Secondary axis". ---- Regards, John Mansfield http://www.pdbook.com "Derrick" wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a second "y" axis on the right?
OK, what if I want a second y-axis but it's essentially the same as the
original y-axis, only in a different format? In other words, I don't actually have two columns of data, I just want to represent the axis in two different ways, one on the left and one on the right. "Andy Pope" wrote: Hi, The principal is the same just the UI is different. Create the chart with the 2 series. Select the series called "Ser2". On the Layout or Format tab use the Format Selection within the Current Selection group. On the Series Option tab select Secondary axis. Cheers Andy Lost_in_Houston wrote: This works great in Excel 1997-03, but how do you do this in Excel 2007? Lost_in_Houston "John Mansfield" wrote: Derrick, Create a simple line chart as an example with the following data: Ser1 Ser2 a 1 4 b 2 3 c 3 4 In the clart plot area, double-click on the series called "Ser2". It should be the higher line of the two series. In the Format Data Series dialog box, go to the Axis tab. Choose the option "Plot series on: Secondary axis". ---- Regards, John Mansfield http://www.pdbook.com "Derrick" wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I create a second "y" axis on the right?
So either plot the same series twice, once on each axis, or plot some dummy
data as I suggested in your other post. _ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "mikeweasel" wrote in message ... OK, what if I want a second y-axis but it's essentially the same as the original y-axis, only in a different format? In other words, I don't actually have two columns of data, I just want to represent the axis in two different ways, one on the left and one on the right. "Andy Pope" wrote: Hi, The principal is the same just the UI is different. Create the chart with the 2 series. Select the series called "Ser2". On the Layout or Format tab use the Format Selection within the Current Selection group. On the Series Option tab select Secondary axis. Cheers Andy Lost_in_Houston wrote: This works great in Excel 1997-03, but how do you do this in Excel 2007? Lost_in_Houston "John Mansfield" wrote: Derrick, Create a simple line chart as an example with the following data: Ser1 Ser2 a 1 4 b 2 3 c 3 4 In the clart plot area, double-click on the series called "Ser2". It should be the higher line of the two series. In the Format Data Series dialog box, go to the Axis tab. Choose the option "Plot series on: Secondary axis". ---- Regards, John Mansfield http://www.pdbook.com "Derrick" wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
| How do I create a Line-Column on 2 Axis chart that allows more... | Charts and Charting in Excel | |||
| interchangine catergory and values axis | Charts and Charting in Excel | |||
| catergory on the X axis; values on the Y axis | Charts and Charting in Excel | |||
| Secondary Axis? | Charts and Charting in Excel | |||
Linear Mode
