• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart with Blank Spaces

Thiago Balduino

New Member
Hey Guys.

I'm trying to do a simple Dashboard let me explain in parts.

1 - I have the one sheet of data, that have things like date, order quantity,amount of net weight and etcetera.
2 - The first problem , I have some dates that doesn't have orders.
3 - Then I started to do the compilation sheet.
4 - The compilation is normal, I made a data validation with a list of months.
5 - When the months is selected excel gives me all day of this month and I made some sumifs and countifs using the date as a criteria. But how I only have orders in working days starts to shows some "blank space" in the weekends or hollydays;
6 - And then I tryed to apply some "#N/D" in the blank space but didn't work
7 - Now my chart is full of blank spaces and make my chart ugly.

chartproblem.png
 

Attachments

  • chart problem_2.jpg
    chart problem_2.jpg
    268.8 KB · Views: 1
Back
Top