Need Help for Dynamic Graph

[SP]

Hello,


I am working on Excel Graphs, I need a graph to show three years data 2011, 2012 and 2013. For the past 2 years (2011 and 2012) I have data available for all the months but for the current year I get the data end of every month. Now I want my graph to take (plot) the data only for the available months and I don't want it to dip when there is no data for a particular month. Can I get a solution to this problem?


Regards,

SP

 

[DaveTurton]

The chart will not plot #N/A values so you could put in the cells =NA()

 

[Faseeh]

Hi SP,


Welcome to the Fourms. Either use Dave's suggestion for follow this post of Chandoo:


http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/


Kindly read the Fourth Green Sticky Post on Forums Home Page as well, it will help you get quicker responses from this forum.


Regards,

 

[SP]

Thanks for the responce Dave and Faseeh,


Dave,


I used =na() it works.. But I already have a formula in the cell how to use this with my formula? The data will not be manually input every month it gets refresh on monthly basis so I have to keep the formula.. Can you help me in this?


Thanks a lot.


SP

 

[SP]

Hi Dave,


I used if iserror formula and insted of blank my formula will be giving an #na value whereever the data is unavilable eg =IF(ISERROR(G86/G81),"#N/A",(G86/G81))


But I am not getting the result what I need. My Graph is plotting zero :-(

 

[SP]

Thanks a ton...


i GOT IT WORKED!!!


Regards,

SP

 

[DaveTurton]

You are welcome,