MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Not including zero values in an excel chart


Posted by Chris Hickey on December 04, 2001 2:12 PM

I am trying to create a chart that shows data for sites by time. I can't figure out a way to make the chart not graph 0 values. E.g. Months from July 2001 to July 2002 will have data in it until December (when I posted this) but the values for the rest of the period will be blank which is interpreted as Zero and hence gets charted. Anyone with ideas please feel free to e-mail me.

Thanks

Chris.


Posted by Mark W. on December 04, 2001 3:10 PM

Fill in these empty cells with #N/A

Posted by Bariloche on December 04, 2001 6:05 PM

Chris,

If you want this to be the default behaviour, go to Tools > Options > Chart and select how you want empty cells plotted.

enjoy