A column chart shows 0 for column series

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

A column chart shows 0 for column series

Post by BittenApple »

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
Last edited by BittenApple on 09 Nov 2021, 22:36, edited 1 time in total.

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: A column chart shows 0 for column series

Post by HansV »

Without seeing the workbook it's difficult to know what's going on.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: A column chart shows 0 for column series

Post by BittenApple »

Hans,
I think I can create dynamic name ranges to go around this.
Thanks for all your support.
Bit