I am trying to put together a petroleum consumption projection for my
University and need to reference a trendline equation.

I have it set up so every year, we can enter in that years petrol.
consumption and the graph updates, then the trendline updates, but the
projected figures (a list going out to 2020) does not. This is because to get
the projections, I had to manually copy the trendline equation to the cell,
referencing appropriate cells (i.e. the year).

If I could set up an absolute reference to the equation, whenever it was
updated, the projected figures would also be updated but I cannot figure out
how to do this. Sorry for the wordy post, thanks for any help.

--
CMS