Originally Posted by
SLOLouDog
I have a table of data, below.
Company Days Volume
A 4 10
B 5 20
C 6 30
D 7 40
E 8 50
This table will remain the same size (# of rows & columns) regardless. The data within the table, "Days" and "Volume" will change. I have a Bar Graph for the "Days" which changes just fine when the data is altered. However, I am using a Pie Chart for "Volume," and when the data is altered the pie chart does not update the value, the corresponding pie slice, or percentage based on the value. WHY???? Does it matter that these values are being referenced from a different sheet of data? Then referenced again for a chart?
Thank you.
Bookmarks