+ Reply to Thread
Results 1 to 2 of 2

Chart Legend Entries

  1. #1
    BillCPA
    Guest

    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. #2
    Registered User
    Join Date
    04-20-2005
    Posts
    48
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1