Ok, I figure sombody must have come across this before...
Problem 1) So I have a pivot table with a linked pivot chart(graph)
I want to be able to automatically print an idividual chart for each of the selections for the pivot table. (instead of the go to drop down, make selection, click to chart, ctrl-P, etc..for each chart.)
Problem 1A) So what I REALLY want is to create a PDF of each chart...the problem here is that adobe is not part of excel, so the macro commands dont work there, so I cant enter separate titles for each PDF or even click OK in the pdf window as part of the excel macro.
Theoretically, I should be able to copy and paste the title of each chart as the name of the associated PDF...but I can't seem to make this a reality...
Josh.
Problem 1) So I have a pivot table with a linked pivot chart(graph)
I want to be able to automatically print an idividual chart for each of the selections for the pivot table. (instead of the go to drop down, make selection, click to chart, ctrl-P, etc..for each chart.)
Problem 1A) So what I REALLY want is to create a PDF of each chart...the problem here is that adobe is not part of excel, so the macro commands dont work there, so I cant enter separate titles for each PDF or even click OK in the pdf window as part of the excel macro.
Theoretically, I should be able to copy and paste the title of each chart as the name of the associated PDF...but I can't seem to make this a reality...
Josh.
