print charts

[jongiff]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

What is the best way to print a chart. In Excel 2003 you just selected the chart and then file/print. In Excel 2008 this now prints the chart and all it's source data. If I switch to page layout view it clobbers freeze panes in the source sheet. It used to be so easy...

 

[Monty Lee]

Did you ever get a response? I need to print a chart but can't. 2003 was easy, but 2008 I just can't figure out how to print JUST the chart. I've resorted to taking a screen snapshot, but there has got to be a better way!

 

[CyberTaz]

Yeah, it's a bit of an inconvenience, but no that tough

Select the range of cells occupied by he chart, then in the Print dialog
choose Selection under Print What.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Ken]

I tried that approach, but it only prints the selected cells. The goal is to
print the chart, not the cells (the way it used to work). Any thoughts?

 

[CyberTaz]

Are you clicking the "Selection" option under Print What: in the Print
dialog? Works here - to paper or to PDF.

Regards |:>)
Bob Jones
[MVP] Office:Mac