EdTech Help GuidesGS107 ExcelHow Do I Create A Graph In Excel? (copied)

How Do I Create A Graph In Excel? (copied)

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) or control key (PC), highlight data from (E5:E16).

4. Select the chart icon shown above.

5. Select the 3-D Clustered Bar graph.

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 Quick Layout option.

4. Select the option that shows the legend on the right of the chart.

 

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

0 Comments

Add your comment

E-Mail me when someone replies to this comment