Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Alternate axis at top of chart
i have a number of X-Y scatter plots where I need to have either only an
alternate abscissa axis at top of chart or alternate ordinate on right and abscissa on top. I can easily do the alternate ordinate but can't find a way to do the alternate abscissa. How do I do it. the only option I see at moment is to redraw graphs in Visio and then add the axises. I prefer to use Excel XP but can use 07 if need be. Thanks in advance for any suggestions! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Alternate axis at top of chart
What you need are secondary axes, and you need multiple series in order to
get secondary axes. Right click one of the series, choose Format, and on the Axis tab (XP) or on the Options tab (2007) choose Secondary. Then Excel only gives you a secondary Y axis, so in XP go to Chart menu Chart Options Axes tab, and check the box for a secondary X axis. In 2007 you have to go to the middle Chart Tools tab, click on Axes, and select the secondary horizontal axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bonsai Bill" wrote in message ... i have a number of X-Y scatter plots where I need to have either only an alternate abscissa axis at top of chart or alternate ordinate on right and abscissa on top. I can easily do the alternate ordinate but can't find a way to do the alternate abscissa. How do I do it. the only option I see at moment is to redraw graphs in Visio and then add the axises. I prefer to use Excel XP but can use 07 if need be. Thanks in advance for any suggestions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Alternate Labels on Date Axis | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Alternate Y axis in bar charts | Charts and Charting in Excel | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |