| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Don't want to plot blank cells on my chart
This is the formula in a cell which is plotted as a data point on a chart
=IF(B12=0,"",(100-(B13/(SUM(B12:B13))*100))) It works fine, but I don't want the chart to plot it if the cell is blank ("") I went into Tools - Options - Chart and selected Plot Empty Cells As Not plotted But it still plots the empty cell as zero Please advise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank cells plot as zero values | Charts and Charting in Excel | |||
| How, on a line chart, to skip blank entry rather than plot as 0? | Charts and Charting in Excel | |||
| How do I force a line chart to not plot cells that are "null". | Charts and Charting in Excel | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
| Blank cells in a chart | Excel Worksheet Functions | |||
Threaded Mode
