Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Duplicate Axis Labels

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 103
Default Duplicate Axis Labels

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
x-axis labels sfran19 New Users to Excel 0 November 20th 06 01:32 AM
How to create duplicate labels with mail merge? Beth Excel Discussion (Misc queries) 3 July 5th 06 09:58 PM
labels on the x-axis Enna Charts and Charting in Excel 3 June 9th 06 06:11 AM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
Age in X-axis Labels as "YY;MM" ?? [email protected] Charts and Charting in Excel 5 February 16th 05 02:09 PM


All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"