Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Indicate which axis in legend

I have several series on a chart, some of which are plotted with the
secondary y-axis. Is there a way to indicate for each series, in the legend
or elsewhere, with which axis it is plotted?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Indicate which axis in legend

You could do it in the legend if you append a note to the cell containing
the series name, i.e., change "First Series" to "First Series (primary)".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"hmm" wrote in message
...
I have several series on a chart, some of which are plotted with the
secondary y-axis. Is there a way to indicate for each series, in the
legend
or elsewhere, with which axis it is plotted?



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
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
shift Y axis Terry Charts and Charting in Excel 7 June 25th 06 06:18 PM
switch around info from legend to axis Sallie Charts and Charting in Excel 1 June 8th 06 02:59 AM
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM


All times are GMT +1. The time now is 09:45 PM.

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"