P

#### PaulW

based on numbers one of the series is a percentage, so has it own axis.

I've set up the spreadsheet so that each week when data is added then

another part of the spreadsheet shows it, this part of the spreadsheet only

shows the last 28 weeks, so I have no need to change the cells the graph is

looking at (since it always shows the last 28 weeks)

The problem is that I need to have vertical lines to show different months.

The closest i've managed is to put a seconardy X axis with gridlines for

every month. But this unfortunatly starts where the Y Axis crosses, which is

the 15th May, so this shows the 15th of each month, rather than statically

the first/last of each month.

I've had a look on this forum, and found

http://peltiertech.com/Excel/Charts/AddLine.html

But I couldn't get it to work. I followed it a few times and I must be

getting something wrong because when I paste the information I get a zig zag

line on the left side, it doesn't correspond to the x axis. And when I change

it to scatter type it disappears altogether, and moves the graph so the left

Y Axis goes down to -50, when there are no minus figures on the graph.

Can anyone help me? drawing lines onto the graph and moving them isn't too

productive...