Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I need to show the same axis labels on the left handside and the right hand
side of the xy chart. I can add a secondary axis but them it messes up the trendlines and the both axis labels. Is there a way to have the same labels on both sides of the chart without messing up the trendlines? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
biscuitsmom:
You can get left side axis labels by adding a custom axis, as discussed in thus tutorial: http://processtrends.com/pg_charts_custom_axis.htm To make your custom right axis, add a new data series with X values equal to the maximum value you want on the X axis. The Y values are the label values you want displayed. The tutorial shows how to adjust custom series to look like a right side axis with labels. Kelly O'Day http://processtrends.com "biscuitsmom" wrote in message ... I need to show the same axis labels on the left handside and the right hand side of the xy chart. I can add a secondary axis but them it messes up the trendlines and the both axis labels. Is there a way to have the same labels on both sides of the chart without messing up the trendlines? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
x-axis labels | New Users to Excel | |||
How to create duplicate labels with mail merge? | Excel Discussion (Misc queries) | |||
labels on the x-axis | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
Age in X-axis Labels as "YY;MM" ?? | Charts and Charting in Excel |