This has to be possible but I've reached the end of my teather, please can someone come to my rescue!
I've created a chart based on source data for the next 12 months (to avoid having to change source data every month). The table this is sourcing data from contains all kinds of formulas based on a separate worksheet. Where data in the table is yet to be populated it displays 0's. The chart therefore is displaying 0's for the months that data doesn't exist for.
I've changed all the formula's in the table to not display 0's using IF statements, but this hasn't worked either.
Can someone tell me how to make a chart not display zero values PLEASE?!?!?
Bookmarks