Editing Charts & Graphs

If you can click it, you can edit it!

Note: If you are a novice user of Excel and would like to see more information about charts and graphs, click here – Anatomy of a Chart.

Editing or Adding a Data Series to a Chart

Data for example: Click the chart to which you want to add another data series. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In the … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Editing the Order of the Data Series

Data for example: Click the chart that contains the data series that you want to change. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Editing or Adding a Title

Click anywhere on the chart. On the Chart Tools Layout tab, click the Chart Title button in the Labels group. A list of options appears: None: This choice means you don’t want to display a title. Also use this option … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Editing an Axis

Right click on the horizontal axis and click on Format Axis. In the pop up box Axis Options click on Fixed under Minimum and change the value to 0 and under Maximum click on Fixed change the value to 500. … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Editing the Chart Type of an Existing Chart

To change the chart type of the whole chart, click the chart area or plot area of the chart to display the chart tools. On the Design tab, in the Type group, click Change Chart Type. In the Change Chart … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment