#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Gantt Chart: MS Project vs. Excel | Nance | Project | 2 | 12-09-2008 01:59 PM |
How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
Help with a macro to shade a selected pie chart | hzrvkt | Excel | 0 | 02-24-2006 01:25 PM |
One bar chart for 3 sets of data | rclloyd | Excel | 1 | 02-03-2006 09:51 AM |
Page breaks inserted in Gantt chart have no effect | Steve Sells | Project | 2 | 11-09-2005 08:12 PM |