Split pivot into multiple charts

  • Im trying to create a macro to export Multiple Charts from a Single pivot Table.

    My Table looks something like this (This is just an example, the number of categories like 40-50+ and items keep changing every month)

    Basically i need to create a stack 100% bar chart, with percentage labels, but i am unable to create a loop,

    wondering if there is any way to do this?

    I am assuming we may need to split the data into multiple sheets first? i found this Split Data into Multiple Worksheets Based on Column - Free Excel Tutorial (excelhow.net)

    i got this macro to export each chart to the ppt :

    Could someone help me on how do i go about this and how do i loop thru? i am struggling to get the create chart part correct

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!