Graph problem

[frenchlouis]

Hi everybody,

I edit a graph on excel with blank to fill in a tab. I will fill them in the future, a blank once a week.
The problem is on the graph, the values for these blanks are zero. and i don't want to have any point for the blanks.
Is it possible to hide these zero on the graph and just show the values that i have entered in the tab?
Excuse my english, I'm french.
Thanks for your help.

 

[VoG]

Bonsoir. This may help http://peltiertech.com/WordPress/dynamic-charts/

 

[jberwald]

Lets assume the data for your chart is in Column B. In another column put this formula:

=IF(B1<1,NA(),B1). Drag that as far down as your data goes - and set up your graph to now read this column instead of column B

 

[frenchlouis]

Thank you very much guys. It helps me a lot.