locked
Pivot Chart showing 0 for some reason in blank column, while others do not. RRS feed

  • Question

  • Hi,

    I have a similar scenario. I have a pivot chart made from stagnant cells (not a table), and for some reason, the Sum of Pending column reflects a 0 in the chart for the next day, even though there is no data. There is not any data in the Sum of Completed or Target either, yet they show up blank, as they should. I've suppressed 0's, even though there are none. Why does this one column reflect a 0 on my chart? Trying to upload an image once account verified.

    Thursday, August 23, 2018 3:13 PM

Answers

  • Hi GregExcel,

    Thanks for your question.

    >>> I've suppressed 0's, even though there are none. Why does this one column reflect a 0 on my chart? Trying to upload an image once account verified.
    Please do upload an image for this issue. It is pretty hard to answer this without knowing the exact issue you are facing.


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, August 24, 2018 3:07 AM