Automating Graphs in Excel

[hpatel517]

Hello All,

I have some tasks that I run manually every time I run my models and was hoping to automate some of them. Once the model is run, it generates some graphs, I would to automate the following functions:
- Create a pivot chart per filter item
- Change Title of chart to Selection on Filter
- Change the axis ratio to be as close to a number as possible (by increments of .5)
- in example, the secondary axis is 7 and the primary is 600. The ratio of those is ~85, and the benchmark on the previous tab is 88. Ideally each graph generated would have to be edited to come close to that ratio


Thank you!

[humdingaling]

lets start with the easy things

- Change Title of chart to Selection on Filter

^to do this just change the title to filter
in your example

Please Login or Register  to view this content.

- Create a pivot chart per filter item

assume your pivot table is already setup and this is not part of the macro
So, what do you want to happen with each graph...you didn't stipulate this part?
create pdfs for each graph? copy picture for each graph somewhere?

[humdingaling]

i have something very similar setup already so this is basically what i do

i have a list of every item you want to filter
i put this in your data sheet L2:l5
as mentioned in spreadsheet
its a list of unique values based on your pivot data which you can either set with formula or just do it manually (copy the column and remove duplicates)

Please Login or Register  to view this content.

this code changes thru all the states and creates a pdf into folder "email"
PSyou need to put a subfolder under this file called email or the code doesnt work