dynamic pie chart help

[Dadof2]

Hello - looking to make a pie chart with data that changes by number of rows daily

I have 1000 line items with quantity and type in each column

I want to create a pie chart that sums quantities by type by looking thru the column. Each day when I run this the number of line items will change. some days it will be 800 and some it could be 1200

Is there an easy easy way to do this??

Thanks!!


the Quantity column is AA
and the type column is Y

I know this is easy but I simply can not get the chart to work

[cbatrody]

Hi,

Please post a sample template of your workbook.

[Dadof2]

okay, here it is. I copied the data into two columns. notice the first column has a lot of the same type. I want to do a pie chart where it sums by type. THe second column is quantity

thx!!

[cbatrody]

Hi,

I have created a Pie Chart in the attached file which is linked to a Pivot Table. This gets auto updated as and when you refresh the data.

Regards,
Chandra



Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

[Dadof2]

Chandra - Thanks. You really helped!! Thanks Again!!