12 Days Excel: Part 3

Part 3: Creating Charts & Graphs

Google Instructions

How to make Charts in Google Sheets

Excel Instructions

Here are step by step instructions when creating a chart in Microsoft Excel.

• Select the columns and rows you want to make a chart from. Remember to include the top left empty box of your table when creating your charts (if you don't it will affect your chart and values).
  • If you would like to select separate columns or rows: Click and highlight your first area, and then while holding the Control button (Ctrl) then click and select the other area(s).

• Once you have your areas selected properly, Under the Insert tab in the top toolbar, choose which type of graph you woul d like to use.

Customizing your Chart

Once you select the chart you would like to use, Excel will automatically insert it in your document for you. You will now need to customize how it looks and what info is displayed. The toolbar will have 3 main categories of specifics: design, layout and format.

Design Section

This refers to how the chart will look and how it is displayed here you can changes the colors used in the chart and what direction information is shown.

If you have any problems with creating a chart, remember you can always search the help menu in Excel or check the website links for extra help.

Good Luck and Have Fun!