In-Branch: Expanded hours, technology services, browsing, and small meeting rooms. Returns: At branch desks, and all book drops. Holds Pick-Up: In-Branch or curbside or drive-up service. View current services and how the Library is keeping customers and staff safe. 

The Red Bridge Branch is reopened as of Wednesday, June 23.

Back to top

Four Easy Steps to Create an Excel Chart

Four Easy Steps to Create an Excel Chart

April 6, 2020

Excel charts help people visualize the information you need to explain. Spreadsheets are great at organizing numbers in a meaningful way, but many times, they can just look like a bunch of numbers to your readers.

The example spreadsheet below is a yearly profits summary for a small company. While it is organized into regions and quarters, it’s more difficult to determine how the individual regions are doing.


Create a chart in four easy steps to learn more about ABC Company’s profits.

Step 1: Select the Data

In our example, we’ll select the row and column headings, plus the data for the regions and the quarters. Note that any totals are excluded.


Step 2: Insert the Chart

Click the Insert tab, and then select the chart type. The Recommended Charts button in the Charts group is very helpful in determining which type of chart to select. Be sure to read the information about how the chart type should be used.


Step 3: Move and/or Resize the Chart

The chart generally appears on top of part of the spreadsheet. Use the four-headed arrow mouse pointer to move the chart by using drag and drop. Use the sizing handles (circles on the corners and mid-way on an edge) to make the chart larger or smaller. Click the Move Chart button to move the chart to its own, unique chart sheet.


Step 4: Add/Remove Chart Elements

The + button to the right of the chart displays a list of common chart elements to add or remove.


The Chart Tools Contextual Tab: Design and Layout

Each time you select a chart, the Chart Tools Contextual Tabs will appear to the right of existing ribbon tabs. Use the Design tab for basic layout. Use the Layout tab for even more detailed formatting.


To learn even more about Excel Charts, be sure to visit our great online resources:

We will also be posting short video on the MCPL Facebook page that shows these steps.

Terri M.
Consumer Technology

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.

View All Blogs

Read Similar Blogs:

Resources You May Also Like

Small Engine Repair Reference Center

Get repair info and instructions for small engines.
More Info

Events You May Also Like

A Case of the Zoom(ies) (MCPL360)

Wed, Jul 7 2021
1:00pm - 1:30pm Central
Virtual Event
Looking to set up a meeting with one or 49 people? Join us as we explore setting up a Zoom account and the various ways to set up meetings and video calls using the free version of the service!

Blogs You May Also Like

Microsoft Word: Create a Sheet of the Same Label

Microsoft Word: Create a Sheet of the Same Label

The Mailings tab in Microsoft Word helps automate the process of creating labels, envelopes, postcards, name badges, and m
Read More
How to Create Excel Pivot Tables

How to Create Excel Pivot Tables

If you have a large spreadsheet and find that sorting and filtering don’t give you the answers you need,
Read More
woman using laptop

Your Computer, Your Way: Adaptive Technology for Your Computer

I recently read an article about
Read More

Mail Merges with Microsoft Excel and Word: Part 2

In Part 1
Read More

Was this page helpful? Yes No