Excel 2007 Chart Options
 

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?

Excel 2007 Chart Options
 

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

"michaelberrier" wrote in message
ups.com...
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?

Excel 2007 Chart Options
 

On Feb 5, 12:04 am, "Mike Middleton" wrote:
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

"michaelberrier" wrote in message

ups.com...

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?

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.

Excel 2007 Chart Options
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"michaelberrier" wrote in message
ups.com...
On Feb 5, 12:04 am, "Mike Middleton" wrote:
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

"michaelberrier" wrote in message

ups.com...

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?

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.

Excel 2007 Chart Options
 

On Feb 5, 6:55 am, "Jon Peltier"
wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______

"michaelberrier" wrote in message

ups.com...

On Feb 5, 12:04 am, "Mike Middleton" wrote:
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

"michaelberrier" wrote in message

roups.com...

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?

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.

That works...thanks.

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