Hello, I have a table and I need to plot it.
However rows are something like:
row title: 2012 values: X1 X2 X3 X4 etc.
row title: 2013 values: EMPTY Y1 Y2 Y3 etc.
row title: 2014 values: EMPTY EMPTY Z1 Z2 etc.
The chart shroud show no empty values: the first non empty (or no zero) value is the the first to be displayed.
In practice the chart should show:
row title: 2012 values: X1 X2 X3 X4 etc.
row title: 2013 values: Y1 Y2 Y3 etc.
row title: 2014 values: Z1 Z2 etc.
Basically the user wants to compare different slopes.
I have many of these charts, so I don't want to adjust rows manually.
I have checked the sheet options but it seems to me that it is possible to adjust a single empty value in a sequence, but not to delete all empty/zero in the left side and then shift the full row.
Also I am trying now to filter the data before plotting it, but with no success so far.
Any other ideas? Any link to suggest?
Thank you
F
Bookmarks