Pivot Chart Display Zero Value Columns

alopez

New Member
Joined
Sep 27, 2011
Messages
4
I am using 2007.

I have a set of data I am trying to display with a Pivot chart. I have a report filter for different departments and my horizontal data is dates, vertical is number of tickets opened per day.
When i change the department, the dates when no ticket was opened goes away. I want to see everyday.

Ex. filtered by (All departments)

September 1 / 11 tickets
September 2 / 2 tickets
September 3 / 5 tickets

Filter by IT department

September 1 / 2 tickets
September 2 / 0 tickets
September 3 / 1 ticket

My chart will hide September 2 with the IT filter selected. I want the chart to show September 2 with a zero value.
This is a stacked column chart.

Thanks!
 
Last edited:

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Thanks!

Now i am having a different problem.

When I show items with no data, it is showing too much.

I have dates listed with day and weekday, "9 Friday" that is linked to September in my data. My table also has multiple months and now every day is showing in every month, when 9 friday is only in September. why is it showing data that is linked with September in the other months?
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top