Print charts but not figures

[lukerees83]

If one a particular sheet the page setup shows you are spanning 2 printable pages of A4, 1 sheet with the charts on and the other with the data, can you tell excel to print the charts only but still keep the data visible? This would need to apply to a whole workbook where this situation applies on many sheets.

 

[Andrew Poulsom]

Just set the Print Area to the range of cells underneath the chart.