Greetings,

I have a series of line charts (time-x vs value-y) with axis limits and
data ranges updated automatically. I need to come up with a way to
identify certain periods of time with shading. But I don't wish to
simply draw rectangles because I don't want to have to edit the
location of the shapes every time new data is added. Also, I have
about 30 charts to create and maintain.

So ...

1. Is there a away to associate shape position/size to axis values?

2. If not, are there other charting options that would allow me to
plot time vs value overlayed by bars/columns with widths and locations
dictated by the same time-x axis? In other words, I need the location
and width of the columns to be determined by x axis data.

Thanks in advance!


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=496382