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!
Bookmarks