Chart - empty cells show as 0?

  • Thread starter Christine Wilso
  • Start date
C

Christine Wilso

I dont want empty cells from my data source to show as zero on a lin
chart.
The source data isn't exactly empty as it contains a formula
=IF(C7>0,C7,"")
And I think it is because of the formula my line sweeps down to zeer
for all the months that contain no figures.
How can I get round this
 

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

Don't want to plot blank cells on my chart 4
Empty Cell 3
Return an empty cell 2
Chart display of no value cells 1
Find the first & subsequent cells to contain text in a column & re 28
Chart displaying "blank" cells? 13
Ignoring Blank cells 9
Line Chart - Pivot Chart - Show empty cells as Gaps 2

Top