CHARTS are an excellent way to illustrate complex data which is tedious to understand at a single glance. It also helps to make reports concise and self explanatory. Although there is no provision to create huge charts, there are a few tricks you can use to ensure that your charts can be printed as large as posters. Listed below are few options for you to print large sized charts:

~ If you are creating multi-series charts like bar or column charts to fit in, you can consider breaking them into several clusters rather than club them into a single chart. Thus, you may consider creating 20 charts with 10 series instead of a single chart with 200 series in it.

~ If you are creating single-series charts like pie charts, you can consider printing the chart across multiple pages. Create the chart in the usual manner, but don't place it in a separate chart sheet. Instead, place the chart in the worksheet as an embedded object and enlarge it as much as you require. Make sure that the chart container object is not selected and press [ctrl] + [P] to print the worksheet. In the 'Print' dialog box, make sure that you select either the 'Active Sheet(s)'
Of the 'Entire workbook' option. Proceed to print your chart.

~ If you however, wish to print your chart on a single larger paper, save the chart in a chart sheet and save the sheet as a 'Sing'le File Web Page'. Load the file in the browser and save the image. Print the image in sizes that you wish.