Getting Rid of Blanks that Graphs Zeros

Z

Zero Hater

When I graph a chart from my data subset that includes
some blank cells it graphs them as zeros. How can I make
it skip the zeros and just insert the blank?? Please help
 
Z

Zero Lover

I used my brain and I searched for the answer which is
already posted. Thanks to the person who already answered
my question!!
 

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

Similar Threads

Plotting Graph with dynamic table 3
How to eliminate zero values on graphs when formula calculates 0? 4
How to display zero value in blank fields of Cross Tab query 0
Excel 2007 charts: want to avoid zero values 1
Automatic Macro to create 200 graphs 1
Graphing Question: Blank Lines Problem ? 2
Blank instead of "" 5
Hiding Data Points in a chart 2

Top