You are currently viewing How to modify the data for a chart in excel

How to modify the data for a chart in excel

Excel charts are simple and easy to construct. Since they are automatically drawn, they are less prone to errors that may occur during hand drawing. They are more presentable because they are neat and more visible as compared to hand-drawn charts. After your chart appears on the excel screen, you may need to edit or modify it. Excel is fitted with features that enable the user to modify the chart to his level best. The modified and edited chart looks more appealing. Therefore there is a need to modify the chart after creating it.

To achieve these, different excel features are used. Some of the ways to modify your chart are discussed below.

 

To add chart labels

The labeled chart is well understood as compared to a non-labeled one. Therefore, labeling your chart is necessary and essential. These labels may include title, axes, etc. The following steps are involved in the process of changing the chart's labels.

1. Open the excel application. Then, locate the chart you wish to edit on your storage.

2. Click on the chart displayed. And a chart toolbar appears on the top part of the screen.

3. Click on the layout button, located under chart tools.

4. click on either the labels or axes section depending on what you wish to modify.

5. Finally, click outside the chart to save the modified chart.

To modify chart type.

After converting the data to a chart, you may not be satisfied with the type of chart displayed, and therefore you may need to modify the chart type. Excel ensures this is possible due to the presence of a variety of chart types in it. Thus, the user may edit when the need to do so arises. This is maybe achieved through the following steps.

1. Just like the previous one, open the excel application. Then, locate the chart you wish to edit on your storage.

2. Click on the chart displayed. And a chart toolbar appears on the top part of the screen.

3. On the chart tools, click the Design button.

4. Then, click the "Change Chart Type" on the leftmost side of the design section. Then, choose the type of chart that fits your data best and hit the "Ok" button to confirm the chart's selection.

5. Finally, click anywhere outside the chart to save changes done on the chart.

To modify the format of the chart.

In any document, the format matters a lot. Similarly, when modifying your chart, your chart's format should be a key thing to consider. This is achieved through:

1. Just like the previous one, open the excel application. Then, locate the chart you wish to edit on your storage.

2. Click on the chart displayed. And a chart toolbar appears on the top part of the screen.

3. On the chart tools section, click the format button.

4. Then, proceed in selecting your choice formats from different sections within the Format bar.

5. Finally, click anywhere outside the chart to save changes done on the chart.