I want to create a graph of all values in a column, except the first which is a header. I could do this by selecting the following as Series X Values:
Problem is that I'd have to adjust it for every new value I wanted to add. To get all, no matter how many there are I can do this:
With this the graph shows all values and I don't have to adjust anything when adding new rows. Problem now is it includes the header, which messes things up in the graph. How can I exclude just the first row, without hardcoding the end row?
I suppose I could do the following, which seems to work, but it feels a bit ugly...