Excel Graph problem 2

[JohnAcc]

Hi All,

I am plotting a graph with 2 sets of data and i want to supress zero values. Does anyone know how to do this ? It sounds pretty simple but i can't work it out for the life of me!

Thanx in advance

John

 

[xlbo]

Can't supress zeros. Can suppress #N/As
Convert your 0's to #N/As and it should work

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SkipVought]

John,

Zeros will always plot. You can set a Chart Option to NOT plot EMPTY cells and/or only plot VISIBLE cells.

Tools/Options - Chart Tab



Skip,

http://www.TheOfficeExperts.com

 

[JohnAcc]

Thanx guys,

I used #N/A in the formula and it worked a treat.

Rgds, John

 

[JosephRoy]

Thanks, that worked great. Now that I see the lines on my chart, I find another problem. I have several zero values that I would like to handle the same as the blank cells. Is there any way to supress the zero values, or will I have to somehow modify the underlying query?

 

[SkipVought]

Joe,

Please respond in context in your own thread -- NOT here.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884