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