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.
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.
I've also tried to use Trim("") instead of "", that really empties the cell, but unfortunately no difference.
pfridolf Try using NA() in stead of "" and make sure that you the axis labels in a range that contains number starting with zero.