Close

All MCPL branches will closed on May 30 for Memorial Day. Our Virtual Branch is available 24/7.

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

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:
Technology
Self-Development

Resources You May Also Like

Niche Academy

Get tutorials about a variety of MCPL's online resources.
More Info

O'Reilly for Public Libraries

Access thousands of business and technology books online.
More Info

Events You May Also Like

Blogs You May Also Like

Watercolor 101: Part Two
Read More

Watercolor 101: Part Two

If you missed my last blog, I’ve been taking the online Watercolor 101 class from
Tech Tool Tip: Adding Multiple Destinations in Maps
Read More

Tech Tool Tip: Adding Multiple Destinations in Maps

Last week, a couple came to a
Microsoft Word: Create a Sheet of the Same Label
Read More

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
Whip Those Pre-Winter Chores with MCPL!
Read More

Whip Those Pre-Winter Chores with MCPL!

As summer winds down, I’m sure like me, your thoughts turn to back-to-school events, pumpkin spice everything,

Was this page helpful? Yes No