Can you help me get my chart to look like this?

[Tibbs]

We get a report sent to us in very fancy excel format, and I want to duplicate the design of their bar charts, using their data as I can't customise the charts that they give us.

The y-axis goes from 0 to 200, and the x-axis represents the products. Each product has 6 or 7 subproducts. The bit that I can't do is to have the x-axis crossing the y-axis at 100, but having the x-axis descriptors at the bottom of the chart, below 0. Even if I set the offset to 1000, I can not get it to move down far enough.

Any ideas?

I'm using Excel 2000 SP-3, if that helps.

Many thanks,

Chris

P.S. I've included two attachments of screen grabs of what I can make it look like, and what I'd like it to look like, if that helps...

[Tibbs]

I've managed to figure this out...