Special Edition Using Microsoft® Excel 2000 > Building Charts with Excel > Troubleshooting - Pg. : Creative Edge

Table of Contents

This Book

Special Edition Using Microsoft® Excel 2000

Special Edition Using Microsoft® Excel 2000

Search

Contents

URL

Help

Troubleshooting

Selecting a Chart Element

Q1:	Excel won't let me select a specific chart element.
A1:	Excel gives you two ways to select chart elements: Click the element so the selection handles are showing. Click open the Chart Objects button on the Chart toolbar and select the desired element from the drop-down list.

Changing a Chart Sheet to an Embedded Chart

Q1:	I can't move a chart sheet next to my data table.
A1:	Excel defaults to creating a chart as a worksheet, but you can change the chart worksheet to an embedded chart. Select Chart, Location to open the Chart Location dialog box. Select As Object In and use the drop-down list to specify the worksheet you would like the chart to be embedded in.

PREVIEW

Not a subscriber?

Start A Free Trial