Q1: | Excel won't let me select a specific chart element. |
A1: | Excel gives you two ways to select chart elements:
|
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. |