Hi,
my spread sheet shows my electricity usage for the last 5 years( in weekly jumps). Date against units used.

I want to show last years usage on a line chart and over lay it with a line showing this years usage as it progresses.

I am sure it is not difficult but with my ageing brain I just cant work it out!

One last question- is there a way of entering the current date automatically without typing it in every time I make an entry?

Many thanks,

kairos