How to retain gridlines across coloured zones

[Catalina]

Have an XY scatter chart that I would like to divide into four vertical coloured zones. Can use Draw/Rectangle for the zones but placing them on the chart puts them over the gridlines, and neither the zones can be sent to the back nor the gridlines brought to the front. How can the gridlines be shown over the coloured zones? Am using Excel 2002.

[Jacc]

Right click on the shape and choose Format Object. Under Fill there is a sliding scale for Transparency.

Edit: I just saw that you are using Excel 2002. I can only assume that you have that option there too.
Selecting the shape and hit Ctrl + 1 should take you to the format options interface as well.

[arvind sharma]

Right click on the shape and just choose "send to back". Select plot area and choose 'No fill' and now select 'chart area' and choose 'No fill'. It should work. See the attachment.

[Catalina]

Many thanks for the responses. The solutions worked fine, although the first was the simplest. I used 50% transparency to good effect. Your assistance is appreciated.http://www.excelforum.com/images/smilies/smile.gif

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.