Excel 2010...Skipping empty cells when plotting a chart

[alpswd]

This was so easy to do in excel 2003...However im now using 2010 and i cant figure out how to tell excel to ignore the empty cells for a scatter plot. Any help is appreciated.

 

[GlennUK]

Is it that you can't find the Hidden and Empty Cell Settings dialog? In 2007 it's under Chart Tools, Design tab, Data, Select Data, and a button in the Select Data dialog is pressed to show the Hidden and Empty Cell Settings. ( I don't have 2010 )

 

[jer1]

Is it that you can't find the Hidden and Empty Cell Settings dialog? In 2007 it's under Chart Tools, Design tab, Data, Select Data, and a button in the Select Data dialog is pressed to show the Hidden and Empty Cell Settings. ( I don't have 2010 )

I am trying to skip null values when using pivot graph. I have a range of data with many cells with NULL in them. I want Excel to realise they are empty and not include them in the pivot line graph. I am using 2010. I have tried doing as you suggest from within the pivot graph but it doesnt seem to be stopping the pivot table seeing them as having a zero value.

 

[GlennUK]

I have 2010 now, and having created a PivotTable with some nulls, Excel is skipping the nulls in a PivotChart line chart. So, I can't seem to recreate your problem. Can you confirm that this is all within a PivotChart?