Chart Showing Blank Cells as 0

Hi Paul,

I'm guessing you are referring to the Total Sales line. If so, change the formula in F6 copied down to...

=IF(N(E6),E6,NA())

You can then hide the #N/A by applying some conditional formatting.

Conditional Formatting

• Highlight applicable range >> F6:F32
• Home Tab >> Styles >> Conditional Formatting >> New Rule
• Select a Rule Type: Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =ISNA(F6)
• Format… [Number, Font, Border, Fill] >> Pick White font
• OK >> OK

However, to get the CF to work, you'll have to ditch the alternating colors. The white font will show up on the blue rows so you will still see the #N/A.

Glad to hear that and thanks for the feedback.

An issue came up with entering 0 sales for today. Causes an error.

Try pasting the following into cell F6 and copying down: =IF(ISNUMBER(E6),SUM(E6,F5),NA())
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.