Excel 2007- prevent graph from plotting zeros

S

sportique

I have a spreadsheet which includes a simple "IF" statement - when true this
returns "" - which the spreadsheet displays as 0.0
I can supress this display by using custom format etc, but the associated
chart still plots it as zero.
What I really want to do is for the associated chart to plot nothing (ie a
gap in the line).
I am happy to change the chart setup or the formula to achieve this result.
 

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

zero values 1
Blank instead of "" 5
surface chart 1
Excel 2007 charts: want to avoid zero values 1
Excel 2007: Lines not displaying on Scatter Plots 1
Excel 2007: Lines not displaying on Scatter Plots 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
How do I not plot zero values that result from a formula in Excel? 1

Top