| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I force a line chart to not plot cells that are "null".
These cells are not empty, as they have an IF statement in them to force a
"null", so the setting in Options, to not plot empty cells, is not working. Any ideas? |
|
#2
|
|||
|
|||
|
Hi,
When the cell is not truly empty then something is plotted. See here for the various combinations of cell content and line appearance and possible work arounds. http://tushar-mehta.com/excel/softwa...ity/index.html http://www.andypope.info/charts/brokenlines.htm Cheers Andy Tania wrote: These cells are not empty, as they have an IF statement in them to force a "null", so the setting in Options, to not plot empty cells, is not working. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| how can i add a secondary y-axis to a bar chart (not a line chart) | Charts and Charting in Excel | |||
| BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
