Excel 2007 Chart Options

M

michaelberrier

Finding one's way around Excel 2007's new interface is somewhat like
trying to get Silly String back into the can....

I have a chart that plots four values, one of which is the result of a
formula. The chart sees this as a zero value and thus plots zero's
all the way across the chart. In previous versions (I last used
2002), under Tools---> there was an option to "Active Chart plot empty
cells as..." nothing. I cannot find this anywhere in the new version.

Any ideas anyone?
 
M

Mike Middleton

michaelberrier -

With a chart object selected, choose Chart Tools | Design | Select Data, and
in the Select Data Source dialog box, click the "Hidden and Empty Cells"
button. That might be the option you are seeking.

- Mike
http://www.mikemiddleton.com
 
M

michaelberrier

michaelberrier -

With a chart object selected, choose Chart Tools | Design | Select Data, and
in the Select Data Source dialog box, click the "Hidden and Empty Cells"
button. That might be the option you are seeking.

- Mikehttp://www.mikemiddleton.com

Thanks for looking Mike, but that kind of works backwards from what
I'm looking at.

I want a zero value to be treated as an empty cell so that the zero is
not plotted, if that make sense.
 
J

Jon Peltier

While I agree with your silly string observation, the formula result is
being treated the same in 2007 as in 2003. Instead of returning "" or 0,
your formula should return NA(), which makes an ugly #N/A error in the
sheet, but which isn't plotted in an XY or line chart. Use conditional
formatting to hide the error.

- Jon
 
M

michaelberrier

While I agree with your silly string observation, the formula result is
being treated the same in 2007 as in 2003. Instead of returning "" or 0,
your formula should return NA(), which makes an ugly #N/A error in the
sheet, but which isn't plotted in an XY or line chart. Use conditional
formatting to hide the error.

- Jon

That works...thanks.

Even the Conditional Formatting is markedly and horribly
different....wonder what their goal was in offering us all this "help"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top