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.

Thumbnail

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.

Thumbnail

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.

Thumbnail

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.

Thumbnail

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.

Thumbnail

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.

Thumbnail

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

View All Blogs

Read Similar Blogs:
Technology
Self-Development

Resources You May Also Like

Opposing Viewpoints

Explore current issues and controversial topics.
More Info

MUZZY

Build your language skills with kid-friendly MUZZY.
More Info

Events You May Also Like

Digital Note Taking: Part 2 (MCPL360)

Wed, Jul 26 2023
1:00pm - 1:30pm Central
Virtual Event
Join us as we take a look at some popular note taking apps. If you don’t see this program the first time or want to watch it again, visit the MCPL YouTube channel at youtube.com/MCPLMO.

Blogs You May Also Like

In Case You Missed It, Windows 11 Is Here!
Read More

In Case You Missed It, Windows 11 Is Here!

Do you remember when Microsoft announced the release of the Windows 10 operating systems (OS)? I do.
Watercolor 101: Part Three
Read More

Watercolor 101: Part Three

In case you’ve missed my two previous blog posts, I’ve been writing a series about my adventures in wate
Self-Care: What Is It and How Can the Library Help?
Read More

Self-Care: What Is It and How Can the Library Help?

The term “self-care” may not be new to you, but what does it actually mean?
2021: Cyber Security Jobs Continue to Change and Evolve
Read More

2021: Cyber Security Jobs Continue to Change and Evolve

There are many new types of technology jobs emerging in 2021.

Was this page helpful? Yes No