I have worksheet1 in which I am adding rows of data daily. This data is then
pulled to create various formulated statistics on seperate worksheet2. The
formulated statistics, on worksheet2, are then used to create various pie
charts for volume, %, etc.

When I add new rows of data to worksheet1, the stats on worksheet2 update
correctly. However, the pie chart wedges, percentages, and volume #'s do not
match the the new statistics.

How can these charts be correctly updated without having to re run the
charts everytime?

Do a Google with the search term: Excel dynamic chart
This will lead you to quite a number of sites will tell how to make a
dynamic chart.
But bewared that pie charts start to look odd as the number of slices grows.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SLOLou" wrote in message
...
I have worksheet1 in which I am adding rows of data daily. This data is
then
pulled to create various formulated statistics on seperate worksheet2. The
formulated statistics, on worksheet2, are then used to create various pie
charts for volume, %, etc.

When I add new rows of data to worksheet1, the stats on worksheet2 update
correctly. However, the pie chart wedges, percentages, and volume #'s do
not
match the the new statistics.

How can these charts be correctly updated without having to re run the
charts everytime?

Didn't seem to find really what I'm looking for.

I'm not adding any more wedges. just the size of the wedges will change
along with the value as I input more data. However, the chart wedges and
values do not match the actual values.... Any other thoughts?

"Bernard Liengme" wrote:

Do a Google with the search term: Excel dynamic chart
This will lead you to quite a number of sites will tell how to make a
dynamic chart.
But bewared that pie charts start to look odd as the number of slices grows.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SLOLou" wrote in message
...
I have worksheet1 in which I am adding rows of data daily. This data is
then
pulled to create various formulated statistics on seperate worksheet2. The
formulated statistics, on worksheet2, are then used to create various pie
charts for volume, %, etc.

When I add new rows of data to worksheet1, the stats on worksheet2 update
correctly. However, the pie chart wedges, percentages, and volume #'s do
not
match the the new statistics.

How can these charts be correctly updated without having to re run the
charts everytime?