excel 2010 graph is plotting na()

[spillyy]

has anyone else had an issue with graphs in 2010 plotting #N/A errors?

I do not want the #n/a to show up on the graph. Using the most simple if(a1="",NA(),a1) does not work. Or if I just place an #N/A in the cell, it still shows up on the graph?

i've tried line and column. Any suggestions?

 

[spillyy]

to clarify, the X axis is not actually showing/plotting the text, however, the #n/a are creating blank spacers next to the last month of data....

any suggestions on getting rid of the blank placemarks on the x axis?

 

[Jon Peltier]

What's the rest of the X data look like? Should you be making an XY chart?

The XY chart ignores #N/A in X and Y ranges, where X and Y are numerical values. The line chart only ignores #N/A in the Y range, which is numerical. In the X range, it assumes the #N/A is some kind of label, and makes room for it along the X axis.

 

[spillyy]

Peltier,

Solved the problem by checking out a few of your posts on dynamic ranges. Am now using the offset / count for all my charts... good stuff.

Have learned a ton by checking out your blogs/website. Thanks much. Following you on twitter, keep the tips comin!

-Spil