Forum Discussion
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 points instead of plotting the actual X-value. I guess the trick is to empty the cells, but how?
Below is a simple example. The blue table is entered manually with the last rows empty. The other table contains "". Is there any way of getting these rows to be empty or to plot in another way?
Per Fridolfsson OK! Played around a bit. Try the attached file, using NA() in the column for the X-axis.
7 Replies
pfridolf The only way I can replicate your chart is by shifting the axis labels for the orange line as shown in the picture. Re-align the axis labels (i.e. the reference to column D and the lines will overlap, even when using "" to mark empty strings.
- 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.pfridolf Forget about the NA() part. You don't need it. Have look at the attached file and try to replicate to your own.
