Forum Discussion
Solved
Diagrams with dynamic tables
Hi All I'm sure the answer to this is in the community, but I really can't find it. When plotting a XY diagram from a table containing "non empty cells", Excel seems to count the number of point...
Per Fridolfsson OK! Played around a bit. Try the attached file, using NA() in the column for the X-axis.
Riny_van_Eekelen Thanks for your answer. Unfortunately my tables comes from IF statements with a final sort-function. In the IF statements I have to specify "something" when the condition is not fullfilled. In my case "". As soon as this is the case for the X-values, the diagram won't be correct.
In your Exelfile I added an extra table to underline my problem. (It seems that I'm not allowed to attach files). In cell A19: =IF(ISNUMBER(A2);A2;"") In cell B19: =IF(ISNUMBER(B2);B2;""). (Row 19 to 33). The plot will then be incorrect.
Per Fridolfsson OK! Played around a bit. Try the attached file, using NA() in the column for the X-axis.
- Seems like the NA() does the trick. Thank's a lot.