Automatically Updating Chart

[Jaredm577]

Hi everyone,

Hopefully this is a easy one, I am trying to create a clustered column chart that displays how many products are being sold. These products will vary in item code (A,B,C, etc.) and in thickness (5, 10, 20, etc.).

I would like to group these item/thickness combinations on a graph so I can see how much of each is being sold. Currently, I can get the chart to display the correct information
however if a new product is added to this list the chart does not update? Is there a way that if a new product is added to the list, the chart updates?

I apologise if my explanation is poor, its a bit difficult to describe! I have attached the folder I am working on and thank you for your time!

Any help would be greatly appreciated!

[protonLeah]

You can use a sheet change event to update the Pivottable when the data table is modified:

Please Login or Register  to view this content.

[Jaredm577]

I think I figured it out, similar to your sub that would run when the workbook is changed, I used the RefreshAll command and it seems to work just fine!

Thanks again for your help!