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.

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.
