You could do one of two things...

1. Create a dynamic chart
a. This is a little difficult to design, but it is a no brainer once it
is all in place. You can research the web on how to do this if this is a
method you might prefer.Here is one link for this method:
http://www.bmsltd.ie/Excel/SBXLPage.asp (and look for the FunChrt1)
2. Utilize the pivot table and pivot chart features inherit in MS Excel
a. Each time you update your data (as long as the information is
contiguous), you can go to your pivot table and refresh it.
b. Then you can recreate a pivot chart from this table. It may seem
repetative, but it is rather quick in comparison to other methods.

"Dale Fye" wrote in message
...
I'm using Office XP and have inherited a spreadsheet from someone who
departed my organization. I cannot figure out what he has done (I'm
mostly
an Access developer), so am trying to start over and duplicate his
results.

I'm having difficulty formatting (actually defining) a chart so that I
don't
have to redefine the data ranges every time my data gets updated. I would
use a pivot chart, but have not figured out a way to get the legend to
float
over the graph like in normal charting.

My data looks something like the following, and is linked to an Access
query. The types of mission and the number of days will vary depending on
several factors, so I don't want to have to reformat the data ranges every
time I requery the Access query. What I want to do is create a stacked
bar
chart, where the Mission categories are the labels, the Days are displayed
on
the X-Axis, and the CountOfSorties values are stacked in the chart.

Mission Day CountOfSorties
A 1 3
A 2 5
A 3 7
B 1 10
B 2 5
B 3 4
C 1 12
C 2 8
C 3 9

Any help would be greatly appreciated.
--
Email address is not valid.
Please reply to newsgroup only.