| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can blank cells be omitted from graph?
I have created a graph in Excel 2007 that has 4 data series. However, in
many instances I will only have data entered for 1 or 2 of those series. Currently, the blank series are being plotted as zero values. Is there a way to define the data series so that if they are blank they will be completely omitted from the graph? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exclude blank cells in a line graph | Charts and Charting in Excel | |||
| Blank Graph After Hiding Cells | Excel Discussion (Misc queries) | |||
| Blank cells in graph | Charts and Charting in Excel | |||
| How do I leave out blank cells in a line graph? | Charts and Charting in Excel | |||
| Do not want chart to graph cells with formulas that are "blank" | Charts and Charting in Excel | |||
Threaded Mode
