Results 1 to 1 of 1

Thread: Removing 0 values from data and legend

  1. #1

    Removing 0 values from data and legend



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All

    Well this is my first question in Xl GURU , hope I can explain better

    I have made a graph, which is taking a data from a table (please see the attached file). The problem is; sometime there is no data in a series value, still excel take it as a blank-legend. I tried using NA() in condition but nothing worked, maybe someone could suggest me a macro

    Here one question arises: why didn't I make the graph directly from the pivot table? The reason behind this is that I want to show the total across the row in front of the bar (you might have aware of this trick), so I had to create a separate table with totals.

    Please anyone suggest me a way to remove 0 and unwanted legend in this graph

    Thanks in advance!!
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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