Split pivot into multiple charts

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

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