#1   Report Post  
BillCPA
 
Posts: n/a
Default Chart Legend Entries

My chart has about a dozen data series in it, with a legend created for each.
A couple of the data series currently are zero amounts, and my boss prefers
not to show the legends for the zero amount data series in the chart legend.

I understand how to delete the legend name from the chart legend and leave
the data series as part of the chart. Is there some way to check each data
series when the chart (or worksheet) is activated, see if the amount is no
longer zero, and if so, reinsert the legend information for that data series
in the chart legend?

--
Bill @ UAMS
  #2   Report Post  
carlyman
 
Posts: n/a
Default


The only "automatic" way I have found around this problem is to use
Pivot Charts. If there is no data for a series, it will not be shown
on the legend.

And if for some reason it is on the legend, you un-select it from the
legend drop-down menu.

-JC


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=390746

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 hide a dummy series in a chart legend? holg3r New Users to Excel 2 July 14th 05 09:04 AM
Specifying Legend Entries Joey Chart User Charts and Charting in Excel 1 June 23rd 05 12:34 AM
Stack Chart Legend Display John Charts and Charting in Excel 1 May 15th 05 03:44 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 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


All times are GMT +1. The time now is 03:11 AM.

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

About Us

"It's about Microsoft Excel"