B
Brian McEwan
I need to plot my data as individual series on an x-y plot (i.e. each
series only contains one point) and add an intercept line through one
of these series. In versions of Excel prior to 2007, I was able to add
a trend line to a series (again, a single point) and then format it
such that it went through the x- or y-intercept of my choice; however,
in Excel 2007 I am not able to do this. If I add a trend line, it will
appear in the legend, but I will be unable to format it and it does
not appear.
I have found a way around this by adding the intercept to the data
series, but this involves reorganizing my data and it is not ideal. Is
there any other way to do this, or is there a possibility of this very
useful feature returning to Excel?
Thanks.
series only contains one point) and add an intercept line through one
of these series. In versions of Excel prior to 2007, I was able to add
a trend line to a series (again, a single point) and then format it
such that it went through the x- or y-intercept of my choice; however,
in Excel 2007 I am not able to do this. If I add a trend line, it will
appear in the legend, but I will be unable to format it and it does
not appear.
I have found a way around this by adding the intercept to the data
series, but this involves reorganizing my data and it is not ideal. Is
there any other way to do this, or is there a possibility of this very
useful feature returning to Excel?
Thanks.