Results 1 to 8 of 8

Thread: Legend issue on graphs
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2009
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Legend issue on graphs

    Hi All,
    I have a graph showing a set of data (from a pivot) which is only showing 6 items at the moment (which is correct) but the legend is showing all the other possible items that are included in the pivot but has a value of zero.


    Is there a way that the legend will only show items that are greater than 0 at all?

    Regards
    P

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,604
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Legend issue on graphs

    What kind of chart is it?

  3. #3
    Board Regular
    Join Date
    Jun 2009
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Legend issue on graphs

    Quote Originally Posted by RoryA View Post
    What kind of chart is it?
    Bar chart with data being pulled from a pivot in the same workbook

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,604
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Legend issue on graphs

    Is it a pivot chart, or a regular chart that happens to be looking at a pivot table? ALso, did you filter the pivot table to exclude fields with 0 values? A pivot chart should always show whatever is shown in the pivot table (other than grand totals).

  5. #5
    Board Regular
    Join Date
    Jun 2009
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Legend issue on graphs

    pivot chart

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,604
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Legend issue on graphs

    And the answer to my other question?

  7. #7
    Board Regular
    Join Date
    Jun 2009
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Legend issue on graphs

    sorry Rory
    It wont allow me to filter out the Zeros, So i think that may be my issue with the actual data set :'( My bad

  8. #8
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,604
    Post Thanks / Like
    Mentioned
    47 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Legend issue on graphs

    If they are in the pivot table, they will be in the chart. Why can't you apply a row/column value filter to remove the 0 values?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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