Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joey Chart User
 
Posts: n/a
Default Specifying Legend Entries


Does anyone know of a way to either specify a range for the lengend
entries or make a custom legend without usig a text box. When using a
text box, it is not WYSIWYG and is a problem to size properly for
printing. Because of the way the data varies, creating a separate
series for each group of data representing legend entries isn't
practical. Thanks


--
Joey Chart UserPosted from http://www.pcreview.co.uk/ newsgroup access

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

The legend is based on the different series in the chart: by default
each series has an entry in the legend. You can't add entries to the
legend which are not separate series (though you can delete an entry and
keep the series in the chart).

I've seen few cases in which separate series couldn't be defined from a
single range of data. One way is described in this page:

http://peltiertech.com/Excel/Charts/...nalChart1.html

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


Joey Chart User wrote:

Does anyone know of a way to either specify a range for the lengend
entries or make a custom legend without usig a text box. When using a
text box, it is not WYSIWYG and is a problem to size properly for
printing. Because of the way the data varies, creating a separate
series for each group of data representing legend entries isn't
practical. Thanks


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
XY Scatter Legend when Edit Individual Markers John Charts and Charting in Excel 6 June 13th 05 03:06 PM
Subscript in legend? Suzan Charts and Charting in Excel 2 June 3rd 05 12:55 PM
I have 36 legend entries but only need the ones actualy graphed Simon Charts and Charting in Excel 4 April 27th 05 11:37 PM
How do I change multi-line entries to single line entries in Exce. CPOWEREQUIP Excel Worksheet Functions 3 April 14th 05 12:38 AM
How do I change the order of the legend entries? Kerrin Charts and Charting in Excel 1 January 10th 05 11:03 PM


All times are GMT +1. The time now is 08:17 PM.

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

About Us

"It's about Microsoft Excel"