Hide 0 Value from Bar Chart

[beenanu999]

Hi,

How I can hide 0 value in Bar Chart, same chart needs to be updated regular basis (Using Counifs for getting data)
See the attachment.

[Pete_UK]

Do you mean that you don't want to see a category if there are no values for it? If so, put this formula in G2:

=SUM(B2:E2)

and copy it down to the bottom of your data. Then apply AutoFilter to column G, and in the filter drop-down unselect zero.

Your chart will now be compressed and only show the three categories that have values greater than zero. If your values change then you will need to reapply the filter, as this is not dynamic.

Hope this helps.

Pete

[beenanu999]

Thanks Pete,
I m looking for Dynamic.. bcz I need to extract the data from many projects in weekly basis.

[popipipo]

Chart update via pivot table and VBA

[beenanu999]

Thanks a lot.... I will check and update you, please clarify if I want to use another work book how I can do that

[popipipo]

Behind the chart you find a pivot table.
The macro update the pivot table and the chart.