Creating Charts HELP!!

[lhk201]

Is it possiable to create a chart in excel which ignores blanks.

I want the chart to show all months of the year but the months that have not passed as yet have no figures. Currently this is pulling all the variables down to 0 on the chart. Instead of dropping to 0 I want it to just stop. Is this possiable?

Thanks!

 

[VoG]

See Control How Empty Cells are Plotted http://office.microsoft.com/en-us/e...asize-data-in-an-excel-chart-HA001034608.aspx

 

[lhk201]

Thanks for this,

there is formula in the cells so for some reason it doesn't seem to count as blank even though it is.

Is there any way round this?

 

[VoG]

One way is to adjust the formulas so that they return NA() instead of "".

Or perhaps look at dynamic charts http://peltiertech.com/Excel/Charts/Dynamics.html

 

[lhk201]

I replaced the "" with "NA()" is that what you ment?

 

[VoG]

Without the quotes NA()

 

[lhk201]

Perfect thank you!