Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make "secondary x axis labels"
Ive added secondary y axes before, so you can have a series relating to the
left hand axis and one on the right, but with a common x axis but is there an easy way to have two x axis, one at the top and one at the bottom. i don't actually need a 2nd series, but I want my charts to have one unit across the bottom (dose) and another along the top (exposure index) just for reference, so that visually I can look at the curve and read off either dose (at the bottom of the chart), or exposure (at the top) thanks in advance |
#2
|
|||
|
|||
A simple way to do it is to plot your data twice. change the axis on one and
set line and sybol to none for one. in input the two x lable sets "Lee Harris" wrote: Ive added secondary y axes before, so you can have a series relating to the left hand axis and one on the right, but with a common x axis but is there an easy way to have two x axis, one at the top and one at the bottom. i don't actually need a 2nd series, but I want my charts to have one unit across the bottom (dose) and another along the top (exposure index) just for reference, so that visually I can look at the curve and read off either dose (at the bottom of the chart), or exposure (at the top) thanks in advance |
#3
|
|||
|
|||
"Lee Harris" wrote: Ive added secondary y axes before, so you can have a series relating to the left hand axis and one on the right, but with a common x axis but is there an easy way to have two x axis, one at the top and one at the bottom. i don't actually need a 2nd series, but I want my charts to have one unit across the bottom (dose) and another along the top (exposure index) just for reference, so that visually I can look at the curve and read off either dose (at the bottom of the chart), or exposure (at the top) thanks in advance "bj" wrote in message ... A simple way to do it is to plot your data twice. change the axis on one and set line and sybol to none for one. in input the two x lable sets can you do that with x axes though? I've done it before with y axis but not x axis |
#4
|
|||
|
|||
Lee -
Sometimes you need to insist that Excel provide the secondary X axis. When you assign a series to the secondary axis, Excel usually just provides the secondary Y axis. You can go to Chart Options on the Chart menu, and on the Axes tab, specify which primary and secondary axes you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lee Harris wrote: "Lee Harris" wrote: Ive added secondary y axes before, so you can have a series relating to the left hand axis and one on the right, but with a common x axis but is there an easy way to have two x axis, one at the top and one at the bottom. i don't actually need a 2nd series, but I want my charts to have one unit across the bottom (dose) and another along the top (exposure index) just for reference, so that visually I can look at the curve and read off either dose (at the bottom of the chart), or exposure (at the top) thanks in advance "bj" wrote in message ... A simple way to do it is to plot your data twice. change the axis on one and set line and sybol to none for one. in input the two x lable sets can you do that with x axes though? I've done it before with y axis but not x axis |
#5
|
|||
|
|||
"Jon Peltier" wrote in message ... Lee - Sometimes you need to insist that Excel provide the secondary X axis. When you assign a series to the secondary axis, Excel usually just provides the secondary Y axis. You can go to Chart Options on the Chart menu, and on the Axes tab, specify which primary and secondary axes you want. - Jon thanks Jon, I get that bit, but how is the 2nd x axis included in the chart? If I add another series it has the same x axis as the 1st, so moving it onto the secondary y axis won't help. To move it onto a secondary x axis, there needs to be secondary x axis data, this is where I'm having trouble. If you just add a series to a chart, and it has a different x axis it messes up the whole chart. Or maybe I just need to do the chart options and it will refix itself? I'll give it another go when I get in cheers |
#6
|
|||
|
|||
Lee -
If you assign the series to the secondary axis, then get the X axis through the chart options dialog, both X axes will be the same. Now go to Source Data (Chart menu), Series tab, and assign the proper X data for the secondary axis series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lee Harris wrote: "Jon Peltier" wrote in message ... Lee - Sometimes you need to insist that Excel provide the secondary X axis. When you assign a series to the secondary axis, Excel usually just provides the secondary Y axis. You can go to Chart Options on the Chart menu, and on the Axes tab, specify which primary and secondary axes you want. - Jon thanks Jon, I get that bit, but how is the 2nd x axis included in the chart? If I add another series it has the same x axis as the 1st, so moving it onto the secondary y axis won't help. To move it onto a secondary x axis, there needs to be secondary x axis data, this is where I'm having trouble. If you just add a series to a chart, and it has a different x axis it messes up the whole chart. Or maybe I just need to do the chart options and it will refix itself? I'll give it another go when I get in cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Changing Secondary axis value units | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
secondary axis scale | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |