Hi,

The simplest thing is to use an additional data series and create your own
gridlines.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"GS80" wrote in message
...
Hi,

I'm looking to create a column chart which will have a multi level
category
(2 categories). I'd like to output this chart so that the major gridlines
split the columns where the second of the two categories chages. E.g. i
may
have a category for yearly quarters and below this one for semesters. I
would
in the case want lines going vertically through the chart where the
semester
chages. Is this possible in Excel 2007, if so could someone please shed
some
light on how to do this.

Thanks,

G