Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
I have a chart that has two Y-axes, the primary on the left and the secondary
on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
No, the primary is on the left, but you can shift the series currently on
the secondary to be primary, and then shift the series which are currently on the primary to secondary. -- David Biddulph "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
Thanks David...that's what I did, but I was wondering if there was an easier
way. It tends to get messy with stacked columns and multiple lines. "David Biddulph" wrote: No, the primary is on the left, but you can shift the series currently on the secondary to be primary, and then shift the series which are currently on the primary to secondary. -- David Biddulph "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
Yes, you can switch them, but you'll have to temporarily introduce the
secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
Worked perfectly!
Thank you very much! "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
On Mar 9, 12:42 pm, "Jon Peltier"
wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ This worked well; thank you. But the gridlines are still aligned with what used to be the primary Y axis (and is now the secondary Y axis). How can I get the gridlines to line up with the new primary axis? Thanks. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
This worked perfectly for my situation, but now I'd like to reverse the order
of the legend entries so that the legend reference on the left corresponds with the left axis (and, consequently, the right reference matches the right axis). How? I'm getting a headache. "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
Switch the legend entries? Or switch the axis titles?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rutabaga" wrote in message ... This worked perfectly for my situation, but now I'd like to reverse the order of the legend entries so that the legend reference on the left corresponds with the left axis (and, consequently, the right reference matches the right axis). How? I'm getting a headache. "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
Hi Jon,
I'd like to switch the legend entries. As it is now, the legend entry, which I've place on top of the chart, has "% of Entries" on the left and "# of Entries" on the right; but the % axis is on the right, which, of course, means the # axis on the left--which is the way I want them. I just wish I could force the legend entries to swap sides. You have a great website, by the way. Thanks for any help, Mark "Jon Peltier" wrote: Switch the legend entries? Or switch the axis titles? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rutabaga" wrote in message ... This worked perfectly for my situation, but now I'd like to reverse the order of the legend entries so that the legend reference on the left corresponds with the left axis (and, consequently, the right reference matches the right axis). How? I'm getting a headache. "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
I now see a glaring lack of clarity in my original post (apologies). I
should have said "Legend" (singular). I want the references in the legend (which refer to the Y axes) to correspond to the axes themselves; that is, '# of A' is on the left axis, '% of A' is on the right, but in the legend text box, the # is on the right and % on the left. No idea if this clarifies. It's a mush to me now. "Jon Peltier" wrote: Switch the legend entries? Or switch the axis titles? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rutabaga" wrote in message ... This worked perfectly for my situation, but now I'd like to reverse the order of the legend entries so that the legend reference on the left corresponds with the left axis (and, consequently, the right reference matches the right axis). How? I'm getting a headache. "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Switch Primary and Secondary Y Axes
If you go back to the post you first replied to on 8/15, you will see the
steps to switch axes. Plot the items you want on top of the legend on the secondary axis, and put the secondary Y axis on the left. Sometimes when a chart gets complicated like this, it's easier to create a new one with the series in the order and on the axes you need. Then ditch the old chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rutabaga" wrote in message ... I now see a glaring lack of clarity in my original post (apologies). I should have said "Legend" (singular). I want the references in the legend (which refer to the Y axes) to correspond to the axes themselves; that is, '# of A' is on the left axis, '% of A' is on the right, but in the legend text box, the # is on the right and % on the left. No idea if this clarifies. It's a mush to me now. "Jon Peltier" wrote: Switch the legend entries? Or switch the axis titles? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rutabaga" wrote in message ... This worked perfectly for my situation, but now I'd like to reverse the order of the legend entries so that the legend reference on the left corresponds with the left axis (and, consequently, the right reference matches the right axis). How? I'm getting a headache. "Jon Peltier" wrote: Yes, you can switch them, but you'll have to temporarily introduce the secondary X axis (which Excel doesn't add by default). Go to Chart menu Chart Options Axes tab, check the same option of Secondary Category (X) Axis that is checked for Primary Category (X) Axis. Double click the primary X axis (bottom of the chart) and on the Scale tab, check Value (Y) Axis Crosses at Maximum Category. Double click the secondary X axis (top of the chart) and on the Scale tab, UN-check Value (Y) Axis Crosses at Maximum Category. Go to Chart menu Chart Options Axes tab, UN-check the option of Secondary Category (X) Axis that you selected above. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Raph" wrote in message ... I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right? Much appreciated! Raph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Primary & Secondary axes to have same value | Charts and Charting in Excel | |||
Plotting on primary and secondary axes with 'synchronised' y values | Charts and Charting in Excel | |||
Matching the min & max values for Primary and Secondary axes | Charts and Charting in Excel | |||
primary & secondary axis | Charts and Charting in Excel | |||
Lining up scales on primary and secondary y axes | Charts and Charting in Excel |