Forum Discussion

pfridolf's avatar
pfridolf
Copper Contributor
Mar 31, 2022
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...
Charting
excel
pfridolf's avatar
pfridolf
Copper Contributor
Mar 31, 2022
Thank's for your reply. Unfortunately the blue table doesn't exist in reality. It was just created to make the example. In reality the orange table is a number of connected tables (including "") and then sorted by the X-values. The "" will then be at the bottom of the table. As the sorted table varies in length, even the empty rows needs to be plotted.
I've also tried to use Trim("") instead of "", that really empties the cell, but unfortunately no difference.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 31, 2022

pfridolf Forget about the NA() part. You don't need it. Have look at the attached file and try to replicate to your own.

 

  • Per Fridolfsson's avatar
    Per Fridolfsson
    Copper Contributor
    Mar 31, 2022

    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's avatar
        Per Fridolfsson
        Copper Contributor
        Mar 31, 2022
        Seems like the NA() does the trick. Thank's a lot.

Resources