PivotChart Printing Multiple Records

[timsayles1]

I have created a pivotchart. In the field button, you can drop down and select from 430 different patients. When you select the patient, the chart changes to their data. No big deal.

I need to print the charts for each of the 430 different patients from the pivotchart and really do not want to sit here and go click patient, print, click new patient, print.

Is there any solution to this? Thanks!

 

[SkipVought]

Tim,

Please post this code-related question in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[KenWright]

Drag the Patient field up into the PAGE fields, and then using the Pivot Table toolbar use the 'SHOW PAGES' option based on the Patient field to generate a sheet for every patient (Takes about 5 seconds). Now select all sheets and hit print.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------