EdTech Help GuidesGS107 DefaultHow Do I Create A Graph In Excel?

How Do I Create A Graph In Excel?

Below are instructions on how to create and edit a chart in excel.

Using the items in B5:B16 and the data in E5:E16, create a 3D bar chart and place it under the data

1. Select the insert tab.

2. Highlight data from (B5:B16).

3. While holding down the command key(Mac)/control (PC), highlight data from (E5:E16).

If you click twice on one cell while highlighting, your graphic will show the wrong data, and you would have to start this step again.  

In the bar chart, add data labels to show the dollar amount for each item

1. Click on the graph.

2. Select the Chart Design tab.

3. Select the option to Add Chart Element.

4. Select Data Labels option.

5. Select the "More Data Label Options..."

Add a legend to the right of the chart

1. Click on the graph.

2. Select the Chart Design tab.

3. Select the option to Add Chart Element, and then click on "Legend"

4. Select the "Right"option.

 

Change all of the text in the chart to Arial.

1. Select the home tab.

2. Click on the chart.

3. Select the font you want by selecting the icon shown above.

Created by Mallory and Guillermo

0 Comments

Add your comment

E-Mail me when someone replies to this comment