Graphing: creating a y-axis intercept for a trend-line where the x-axis shows dates

[squidgeny]

Hi guys,

I'm having a problem which is really baffling me.

I have a table with two columns:
Column A: Various dates between 1 Jan 2013 and 31 Dec 2013
Column B: Various number values

I have created a scatter chart using this data. The x-axis show dates, as desired. I want to place a trend-line on the graph which intercepts the Y-axis at zero. However, there seems to be no option for this - instead there is an option only to intercept at "zero, zero" which is no good to me because the zero for the x-axis is 1 Jan 1900.

Is there any way to solve this and still keep the date labels on the x-axis?

I realise I can use the formula to calculate the intercept, but new data will be added to this chart all the time and it won't be practical to keep doing that calculation.

Thanks in advance!

 

[RickXL]

Hi,

I don't think I fully understand the issue. Perhaps it would help if you said wht you meant by zero - as in "which intercepts the Y-axis at zero."

If I force the axis to start at the minimum date value then I can add a trend line which reaches the y-axis and indicates an intercept graphically.

Also, I can use the =INTERCEPT() worksheet function to calculate the intercept. Instead of using the real x-axis values I can use those values with the first date subtracted from them all (in an extra column). This gives the value at which the trend line reaches the y-axis assuming that date is "zero".