What kind of chart is it to begin with (i.e., what kind of X axis does it
have)? Have you adjusted the X values of the added series to align where you
want on the original X axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PaulW" wrote in message
...
Hi, I have a report I update each month. And while most of the information
is
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...