CHART MANIPULATION ANNOYANCES
COPY CHARTS AS PICTURES
The Annoyance:
I want to include one of my charts in a Word document, but not as a full-blown chart someone can edit. I want to include just a picture of the chart. Is there a way to do that?
The Fix:
There is, but you wonât find it on any of the standard Excel menus. Not many people know you can get at some alternative menu commands if you hold down the Shift key when you open a menu. Thatâs what youâll do here:
Select the chart.
Hold down the Shift key and choose Edit â Copy Picture, then select the âAs shown on screenâ and Picture radio buttons. Click OK.
Go to your Word document and select Edit â Paste.
MOVE A CHART TO A SEPARATE SHEET
The Annoyance:
I created a chart and left it on the worksheet that supplied the dataâwhich Iâm beginning to think was a mistake. I have to drag the chart around to look at my data! Is it too late to move the chart to its own sheet?
The Fix:
To move a chart to its own sheet, right-click any spot in the Chart Area, choose Location, and select the radio button for âAs new sheet.â Then name the sheet if you want (otherwise, it comes up as Chart1) and click OK to move the chart. The Chart Area is any part of the chart that isnât claimed by the values on an axis, the legend, or the plot in the middle of your chart. If your chart has a legend, plenty of Chart Area space usually is available above or below it (as shown in Figure 5-16).
In any event, just move your pointer around on the chart; ...
Get Excel Annoyances now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.