Printing Charts or Graphs

[JCubed123]

I have made many charts/graphs within a worksheet. In Excel 2004, I was able to select specific charts/graphs and print them. Now I can't even figure out how to print an individual graph on a single page. Does anyone know how to do this in Excel '08?

Thanks!

 

[rlk]

I'm sorry that no one provided a response to this most basic question. I too have had a great struggle generating high-quality, consistently-sized charts from the new Excel. If exported as PDFs, some are poor bitmaps with overlaid vector text, and some won't open in Adobe applications at all, with errors like "An unknown shading type was encountered." And even before export, you must guess at a size so the text will be consistently sized across multiple charts for a presentation. It has been yet another step backwards and ultimately I have had to purchase another package to do quality vector charts.

 

[SCWales]

The easiest way that I have found to print a single chart is to export it as a picture and then print it using Preview, Graphics Convertor, or any other such program. (You could probably even use PowerPoint.) The default choice of xxx.png seems to produce an acceptable resolution. But this is obviously a step backwards. Actually a double-step backwards as there used to be an option to have a chart on a dedicated sheet, which no longer seems to exist. The other option is to place the chart on a single page of the sheet, as defined by the page breaks, and print only that page. Your choice. Hopefully, they get this fixed in an update.

 

[CyberTaz]

One Option: If you want a full-page chart, Control/Right-Click the Chart
Area, select Move Chart - As New Sheet, then print the sheet. When done use
the same method to move it back to where it came from.

Alternatively, select the range of cells covered by the chart object, use
File> Print Area - Set Print Area *or* just select that range of cells & go
to File> Print & choose Selection. Then set Scaling to whatever depending on
the space you want it to occupy on the page.

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