Printing more pages into same PDF

[Jaymond Flurrie]

I'm using Excel 2010 and I know how to print the active chart into a PDF by using VBA. Now the problem I have is that I have too much data to fit nicely into one page of PDF, so I need to use more charts (split the source data into several charts) and then print chart1 into the page1, chart2 into the page2 and so on. The other option is that I use some command to tell PDF that "I want a page break right here". Which one is easier to implement and how do I do that?

Here's the code I'm using right now to print one single chart sheet into one single PDF page:

Sub PrintRadarCharts()
    ThisWorkbook.Sheets("Radar").Activate
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:="C:\printout.pdf", _
    Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub