Don't count 0 in a chart
I want a line chart that does'nt pick 0 or a blank cell as a value for example ' I have a chart with values for the whole month (31 days) and I want the line to be from day 1 to 5 (monday thru friday) then leave blank the next 2 days (6 & 7, saturday and sunday) and then start again on days 8 to 12 and so on. When I make the line chart that line goes graphic to 0
|