Hello all,
I have a column chart and this column chart is based on the values of a pivot table. When I filter the pivot table with slicers, then, some of the fields will show 0s. What should I do to prevent these 0s to be shown in my chart.
Hidden and Empty cells option on select data source dialog box doesn't solve my problem.
I need to find a way when there zero's on the chart, chart doesn't show them, only show the part that there are values for.
Regards,
Bita
A column chart shows 0 for column series
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
A column chart shows 0 for column series
Last edited by BittenApple on 09 Nov 2021, 22:36, edited 1 time in total.
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: A column chart shows 0 for column series
Without seeing the workbook it's difficult to know what's going on.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: A column chart shows 0 for column series
Hans,
I think I can create dynamic name ranges to go around this.
Thanks for all your support.
Bit
I think I can create dynamic name ranges to go around this.
Thanks for all your support.
Bit