+ Reply to Thread
Results 1 to 6 of 6

How to create Pivot tables and charts with zero value

  1. #1
    Registered User
    Join Date
    04-08-2021
    Location
    Limburg
    MS-Off Ver
    2016
    Posts
    3

    How to create Pivot tables and charts with zero value

    Hi!
    I would like to create Pivot Tables that shows zero values for selected dates without existing Data...

    Example:
    I do have customers who don't do turnover every month. But I would like see those months without turnover also in pivot tables and charts as "zero values".

    When I select the customer "B" January will be hidden in the pivot table and the connected chart.
    But I need to see every month in the chart including those without data.

    Image 3.jpg

    Image 4.jpg

    Does anybody have an idea how to manage this?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,890

    Re: How to create Pivot tables and charts with zero value

    Have you selected the option to 'show items with no data' for that field?
    Rory
    I drink, and I know things

  3. #3
    Registered User
    Join Date
    04-08-2021
    Location
    Limburg
    MS-Off Ver
    2016
    Posts
    3

    Re: How to create Pivot tables and charts with zero value

    Quote Originally Posted by rorya View Post
    Have you selected the option to 'show items with no data' for that field?
    WOW...
    This was an easy one.
    Thanks for helping! Best Thomas

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,890

    Re: How to create Pivot tables and charts with zero value

    Quote Originally Posted by trommlertom View Post
    This was an easy one.
    My favourite kind! Glad we could help.

  5. #5
    Registered User
    Join Date
    04-08-2021
    Location
    Limburg
    MS-Off Ver
    2016
    Posts
    3

    Re: How to create Pivot tables and charts with zero value

    Quote Originally Posted by rorya View Post
    My favourite kind! Glad we could help.
    Do you might have another good advice?

    I have created an Excel file with power Pivot tables.

    My problem is, that sometimes excel crashes when I am doing an "export" of details of the pivot table.
    (Double click on the pivot summary...)

    Do you have any idea, how to find the bug that is responsioble for the excel crash?
    Or is there maybe a "repair" function in Excel for such issues???

    Any advice would be appreciated.

    Best Thomas

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,890

    Re: How to create Pivot tables and charts with zero value

    No, I imagine there could be a lot of causes and if you get an error code, you'd probably have to talk to Microsoft to figure out what it actually meant.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. One Data Source....Two Pivot Tables...Two Pivot Charts...
    By shrenikgolchha in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2020, 08:05 AM
  2. [SOLVED] Dashboard for Pivot Tables and Pivot Charts - Question 01
    By phillyfilly in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-27-2017, 06:58 AM
  3. Replies: 0
    Last Post: 07-29-2015, 09:41 PM
  4. Excel Automation: Updating Pivot Tables, Charts, and Tables
    By Lemguin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2015, 04:25 AM
  5. Pivot charts/pivot tables - pulling in visibly the search filter
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-08-2013, 09:07 AM
  6. Pivot Tables & Charts
    By Steve Haller in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-24-2008, 12:51 PM
  7. Replies: 0
    Last Post: 01-19-2005, 06:34 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1