ExecuTrain Houston

May

01

Monthly Tip | Excel 2010 Modify Chart Options

Modifying Microsoft® Excel® Chart Options


Adding/Modifying Titles, Labels, and the Legend


  1. 1. Activate the chart.
  2. 2. On the Chart Tools Layout tab, in the Labels group, click the button of the label to modify.
  3. 3. In the gallery grid, select the appropriate option.

Modifying Gridlines and Axes


  1. 1. Activate the chart.
  2. 2. On the Chart Tools Layout tab, in the Axes group, click the button of the axes to modify.
  3. 3. In the gallery grid, select the appropriate option.

Adding a Background to 3D Charts


  1. 1. Activate the chart.
  2. 2. On the Chart Tools Layout tab, in the Background group, click the button of the background to modify.
  3. 3. In the gallery grid, select the appropriate option.

Modifying Objects Within a Chart


  1. 1. Activate the chart.
  2. 2. Select the item you wish to modify.
  3. 3. On the Chart Tools Layout tab, in the Current Selection group, click the Format Selection button.
  4. Format Axis
  5. 4. In the dialog box, click the item to modify. 
  6. 5. Modify the appropriate options for the related item.
  7. 6. Click the Close button.

Note: Options vary based on the formatting option selected.

Check:

Thank you! One of our advisors will contact you shortly.

Check:

Your information will not be shared or sold. View our Privacy Policy

Your message has been sent successfully!