Charting 0

[tlindeman]

I have a chart that autoupdates with the offset formula and named ranges. Everything works fine except one of my series. I have data from Dec-May for one series and the other series goes from Dec-April. The problem is it is graphing the second series at 0 for May. My question is how do I stop the graph from Graphing May's number for the second series? I know that sounds confusing so please let me know if you need more details.

Thank You
Tony

 

[edvwvw]

If you are using Excel 2007 you can elect to ignore zeros look in Select Data Source - Hidden, Empty cell settings.


edvwvw

 

[Steve=True]

for charting purposes when you have a Zero you want to ignore,

change the cell to =na()

the chart will then ignore the data point for most chart types.