Learn how to Create Excel Charts and Graphs

Excel charts and graphs are tried-and-true instruments for visualizing data clearly and understandably. However for individuals who will not be native tech gurus, it may be a bit intimidating to poke round in Microsoft Excel.

I’m right here to share the foundational data you want, useful video tutorials, and step-by-step directions for anybody feeling like they’re in over their heads.

Organizing a spreadsheet full of knowledge into an correct and enticing chart isn’t sorcery — you are able to do it! Let’s go over the method from A to Z.

What an Excel Chart or Graph is — and Why to Use Them

The very first thing to know is that you would be able to create several types of charts and graphs within the software program.

The distinctive data in your knowledge set(s) and the viewers you might be speaking to are elements that go into selecting the suitable chart or graph in your mission, so let’s chat charts.

However why use them? Do you want to visualise knowledge when you possibly can simply clarify it? The reply is usually sure if you wish to assist an viewers perceive and retain the related findings.

I’ll always remember a selected graph from a TED talk I saw on parenting taboos — and I’ve by no means seen something play out so precisely in my very own life, both:

Image Source

This chart from Rufus Griscom + Alisa Volkman exhibits a imply line of happiness in blue and extra of a moment-by-moment breakdown in yellow of the information factors that construct the imply you see.

The highs and lows are usually much less erratic throughout single maturity as a result of you have got extra management over your atmosphere and circumstances, they clarify, however after you have children? Chaos.

They joked about Grand, explosive moments of affection accompanied by mind-numbing, soul-punching lows — often round bedtime routines. (It’s no joke.)

From this, we will glean that it’s all the time a good suggestion to distill the data into one thing visually digestible so you possibly can talk clearly and effectively.

The very last thing you need is to lose your goal’s consideration in a sea of incomprehensible numbers.

Particularly for big knowledge units, an Excel chart or graph will get to the center of your findings in a manner that’s simple to see and perceive at a single look, particularly whenever you incorporate comparisons.

In case your knowledge has a couple of discovering to speak — akin to a comparability or if you wish to illustrate modifications going down over time — Excel charts and graphs supply a number of choices for creating impactful visuals.

By the top, you’ll have some concepts about which charts may make it easier to inform the tales contained inside your knowledge.

 

The 18 Sorts of Charts in Excel (So Far)

Whew, Microsoft has been busy! Final I did a deep dive, there have been solely 9 kinds of charts, so it has doubled in the last few years — which is good news for analysis communicators.

While you perceive their makes use of, you possibly can current materials optimized to be extremely precious and insightful in your crew’s tasks.

We’ll go over the perfect, tried-and-true choices completely. Then, on the finish, I’ll briefly summarize the superior chart sorts and people who will not be as helpful to entrepreneurs.

Excel Charts Most Helpful to Entrepreneurs

1. Space Chart

Image Source

Excel space charts can help you see traits over time — or another related variable. It’s basically a line graph with colored-in sections emphasizing development and giving a way of quantity.

You may as well use stacked space charts. This denser space chart permits you to present extra data directly, akin to evaluating traits in a number of classes or monitoring modifications throughout totally different variables.

Finest for: Demonstrating the magnitude of a development between two or extra values over a given interval.

2. The New and Improved Bar Graph (Now Referred to as a Clustered Bar Graph)

Image Source

An Excel bar graph represents data horizontally and compares totally different knowledge sequence. You may simply see the proportions between numerous classes or components of your knowledge.

For example, you should use clustered bar graphs to match the gross sales of various merchandise, for instance, in different retailer areas over months or quarters.

This may help you perceive which merchandise promote effectively in several geographies throughout the identical timeframe.

Finest for: Evaluating the frequency of comparable values between totally different variables.

3. Ditto for Column Charts (Renamed Clustered Column Charts)

Image Source

Column charts are just like bar graphs, however they differ in a single vital manner: they’re vertical, not horizontal. The vertical orientation lends itself to serving to viewers rank totally different knowledge components.

Like bar graphs, column charts evaluate knowledge, show traits, and present proportions.

For example, if you wish to rank your gross sales groups’ numbers in several states throughout 1 / 4, you possibly can visualize them in a clustered column chart and see which crew in every state is within the lead — the tallest within the cluster. 

You may as well see which crew is main amongst all states — the tallest amongst all clusters.

Finest for: Displaying numerous knowledge components over a while to rank them visually.

Professional tip: I’ve personally realized that column charts displaying T-bars of statistical significance are extraordinarily helpful in serving to folks in management dispel probably however in the end unfaithful interpretations of knowledge.

Generally, knowledge displaying significant change continues to be inside regular parameters. Generally, what looks like a slight distinction is important.

Managers and administrators might need assistance seeing these realities so that they don’t oversteer at determination time.

4. Line Graph

Image Source

A line graph is an easy however extremely efficient method to see traits over time at a look — even with out the frills of bars, columns, or additional shading. You may as well evaluate a number of knowledge sequence.

For example, the variety of natural visits from Google versus Bing over a 12-month interval.

You may as well see the speed or velocity at which the information set modifications. In our Google vs. Bing instance, a steep incline would imply you had a sudden spike in natural site visitors. A extra gradual decline implies that your site visitors is slowly reducing.

Finest for: Illustrating traits over time, akin to spikes or drops in gross sales attributable to holidays, climate, or different variables.

5. Pie Chart

Image Source

A pie chart is a useful manner of seeing how totally different knowledge components proportionally evaluate to at least one one other. Curious what share of your natural site visitors is from Google versus Bing?

Or how a lot market share do you have got in comparison with rivals? A pie chart is a becoming method to visualize that data.

It’s additionally an effective way to see and talk progress towards a selected objective.

For example, in case your objective is to promote a product day-after-day for 30 days in a row, then you definitely would possibly create a pie chart with 30 slices and shade a slice every day you promote the product.

Finest for: Displaying values as percentages of a complete and viewing knowledge components proportionately.

6. Radar Chart

Image Source

A radar chart would possibly look acquainted to you in the event you’ve ever taken a character take a look at, nevertheless it’s additionally helpful exterior of that business. Radar charts show knowledge in a closed, multi-pointed form.

Every level is known as a spoke, and a number of variables “pull” spokes of the form. Then, shapes may be stacked up for comparability.

The sort of chart is well-designed for evaluating totally different knowledge components, akin to attributes, entities, folks, strengths, or weaknesses. It additionally helps you see the distribution of your knowledge and perceive if it is overly skewed a technique or one other.

Finest for: Evaluating the combination values of a number of knowledge sequence directly.

7. Scatter Plot

Image Source

Scatter plots look just like line graphs however with one vital distinction: They consider the connection between two variables, proven on the X- and Y-axes. This allows you to determine correlations and patterns between them.

For example, you would possibly evaluate the quantity of natural site visitors (X-axis) with the variety of leads and signups (Y-axis).

In the event you see an upward development within the dots the place these two converge, then you definitely’ll have an thought of how a rise in natural site visitors impacts your leads and signups.

In case you have a leads/signups objective, you possibly can then create a extra data-driven plan for growing your natural site visitors.

You may even take it a step additional to match the variety of leads and signups with day by day gross sales or conversions to maintain extra applications on data-driven paths.

Finest for: Visualizing optimistic or detrimental relationships between two variables.

8. Funnel Chart

Image Source

Funnel charts are extraordinarily well-suited to entrepreneurs who wish to optimize processes and pipelines.

Within the picture above, it’s clear that you just drop essentially the most candidates between Certified Prospects and Wants Evaluation, in order that portion of your funnel could also be attention-grabbing to look into extra deeply to grasp why.

Finest for: Visually representing modifications by means of processes helps to make clear the place the most important modifications happen alongside the way in which.

Professional tip: My expertise has taught me that in the event you solely use two ranges — particularly if there’s not a fantastic change between them, it’s simple to mistake this for a bar graph, which capabilities utterly in a different way.

You’ll positively wish to use at the least three ranges so it’s extra clearly distinguished as a funnel form.

9. Histogram Chart

Image Source

Histograms are a stable choice whenever you wish to clarify knowledge that happens most usefully in ranges. Let’s say that you just wish to present your shoppers the shopping for habits of assorted age demographics in your product area of interest.

It’s possible you’ll discover that your audience has moved, presumably even jumped a spread up or down.

In case your consumer has bought child merchandise for the final 100 years, you’d positively see that the audience of first-time mother and father is getting older as folks wait longer to have kids.

This will change your advertising and marketing methods to fulfill the wants and problems with this older first-time mum or dad demographic.

Finest for: Demonstrating knowledge findings which can be most noticeable and helpful when the information is grouped in ranges.

 

Superior Excel Charts

It’s good so that you can know that the next chart sorts exist, however they will not be the perfect place to start out in the event you arrived right here immediately a bit overwhelmed.

They’re extra difficult and higher suited to audiences who can already learn advanced-level charts:

Business-Particular Excel Charts

The remaining Excel chart sorts don’t sometimes lend themselves to advertising and marketing. However, hey — in case your area of interest requires it, these charts are there to help you:

Summarizing the Charts

That was a ton of knowledge. In the event you’re nonetheless undecided which to decide on, right here’s a concise comparability of the Excel charts I discover to be most helpful to entrepreneurs:

Kind of Chart	Use
Space	Space charts display the magnitude of a development between two or extra values over a given interval.
Clustered Bar	Clustered bar charts evaluate the frequency of values throughout totally different ranges or variables.
Clustered Column	Clustered column charts show knowledge modifications over a time period to clarify visualizations of rank amongst knowledge units.
Line	Just like bar charts, they illustrate traits over time.
Pie	Pie charts present values as percentages of a complete.
Radar	Radar charts evaluate the combination worth of a number of knowledge sequence.
Scatter	Scatter charts present the optimistic or detrimental relationship between two variables.
Funnel	Funnel charts excel at visualizing modifications to at least one knowledge level over numerous processes.
Histogram	Histograms present variations in knowledge which can be greatest represented as a spread of values.

In the event you’re searching for a deeper dive that can assist you work out which sort of chart/graph is greatest for visualizing your knowledge, take a look at our free e book, How to Use Data Visualization to Win Over Your Audience.

Learn how to Create a Graph in Excel

The steps to construct a chart or graph in Excel are comparatively easy. I encourage you to comply with the step-by-step directions beneath or obtain them as PDFs if that’s extra environment friendly for you.

Many of the buttons and capabilities you may see and skim are very comparable throughout all variations of Excel.

Download Demo Data | Download Instructions (Mac) | Download Instructions (PC)

Featured Resource: Free Excel Graph Templates

Earlier than we bounce in, it’s time for an additional professional tip. You needn’t begin from scratch. You’re welcome to make use of these free Excel Graph Generators. Simply enter your knowledge and modify as wanted for an exquisite knowledge visualization.

It’s a fantastic time-saver in the event you don’t want one thing as customized as constructing your Excel charts and graphs up from zero.

While you do have to create and customise from the very begin, right here’s the way to deal with it:

1. Enter your knowledge into Excel.

First, it is advisable to enter your knowledge into Excel. You may need exported the information from elsewhere, like a chunk of marketing software or a survey instrument — or possibly you are inputting it manually from spreadsheets. I don’t choose!

Within the instance beneath, in Column A, I’ve a listing of responses to the query, “Did inbound advertising and marketing display ROI?” and in Columns B, C, and D, I’ve the responses to the query, “Does your organization have a proper sales-marketing settlement?”

For instance, Column C, Row 2 illustrates that 49% of individuals with a service stage settlement (SLA) additionally say that inbound advertising and marketing demonstrated ROI.

2. Select from the graph and chart choices.

In Excel, your choices for charts and graphs embody column (or bar) graphs, line graphs, pie graphs, scatter plots, and extra. See how Excel identifies each within the high navigation bar, as depicted beneath:

To search out the chart and graph choices, choose Insert.

3. Spotlight your knowledge and insert your required graph into the spreadsheet.

On this instance, a bar graph presents the information visually. To make a bar graph, spotlight the information and embody the titles of the X- and Y-axis. Then, go to the Insert tab and click on the column icon within the charts part.

Select the graph you want from the dropdown window that seems.

I picked the primary two-dimensional column choice as a result of I desire the flat bar graphic over the three-dimensional look. See the ensuing bar graph beneath.

Nonetheless, if I have been reporting statistics about skyscrapers to a builder’s union, I’d positively decide the three-dimensional look to customise the chart to appear like constructed buildings.

There are optimization selections to make alongside the way in which to greatest suit your knowledge and viewers.

4. Change the information on every axis, if mandatory.

If you wish to change what seems on the X and Y axis, right-click on the bar graph, click on Choose Knowledge, and click on Change Row/Column. This may rearrange which axes carry which items of knowledge within the checklist proven beneath.

Generally, you’ll see that your data simply presents higher a technique versus the opposite. On this case, I believe the primary X and Y orientation is simpler and less complicated to grasp.

Consider, although, that it’s not about me.

If the presentation focuses on SLAs and government choices on whether or not or to not safe one, a Sure/No SLA configuration (the second XY orientation) is probably going a greater match for the viewers and their wants. When completed, click on OK on the backside.

The ensuing graph would appear like this:

5. Modify your knowledge’s format and colours.

To vary the labeling format and legend, click on on the bar graph, then click on the Chart Design tab. Right here, you possibly can select which format you like for the chart title, axis titles, and legend.

In my instance beneath, I clicked on the choice that displayed softer bar colours and legends beneath the chart.

To additional format the legend, click on on it to disclose the Format Legend Entry sidebar, as proven beneath. Right here, you possibly can change the fill colour of the legend, which can change the colour of the columns themselves.

To format different elements of your chart, click on on them individually to disclose a corresponding Format window.

6. Change the scale of your chart’s legend and axis labels.

While you first make a graph in Excel, the scale of your axis and legend labels is likely to be small, relying on the graph or chart you select (bar, pie, line, and so on.)

When you‘ve created your chart, you’ll wish to measurement these labels up so that they’re legible.

To extend the scale of your graph’s labels, click on on them individually and, as an alternative of showing a brand new Format window, click on again into the Dwelling tab within the high navigation bar of Excel.

Then, use the font kind and measurement dropdown fields to develop or shrink your chart’s legend and axis labels to your liking.

7. Change the Y-axis measurement choices if desired

To vary the kind of measurement proven on the Y-axis, click on on the Y-axis percentages in your chart. This reveals the Format Axis window.

Right here, you possibly can determine if you wish to show items situated on the Axis Choices tab. You may change whether or not the Y-axis exhibits percentages to 2 decimal locations or no decimal locations.

As a result of my graph routinely units the Y axis’ most share to 60%, you would possibly wish to change it manually to 100% to signify knowledge on a common scale.

To take action, you possibly can choose the Most choice — two fields down beneath Bounds within the Format Axis window — and alter the worth from 0.6 to at least one.

The ensuing graph will appear like the one beneath (On this instance, the font measurement of the Y-axis has been elevated by way of the Dwelling tab as a way to see the distinction):

8. Reorder your knowledge, if desired.

To kind the information so the respondents’ solutions seem in reverse order, right-click in your graph and click on Choose Knowledge to disclose the identical choices window you known as up in Step 3 above.

This time, arrow up and right down to reverse the order of your knowledge on the chart.

In case you have greater than two strains of knowledge to regulate, you can even rearrange them in ascending or descending order. To do that, spotlight your whole knowledge within the cells above your chart, click on Knowledge, and choose Type, as proven beneath.

Relying in your choice, you possibly can select to kind based mostly on smallest to largest or vice versa.

The ensuing graph would appear like this, which is tremendously higher. Why? As a result of it exhibits your viewers the development of outcomes and turns into visually persuasive.

9. Title your graph.

Now comes the enjoyable and straightforward half: naming your graph. By now, you may need already found out how to do that. This is a easy clarifier.

Proper after making your chart, the title that seems will probably be “Chart Title” or one thing comparable, relying on the model of Excel you‘re utilizing. To vary this label, click on on “Chart Title” to disclose a typing cursor.

You may then freely customise your chart’s title.

When you have got a title you want, click on Dwelling on the highest navigation bar, and use the font formatting choices to present your title the emphasis it deserves. See these choices and my ultimate graph beneath:

10. Export your graph or chart.

As soon as your Excel chart or graph is precisely the way in which you need it, it can save you it as a picture with out screenshotting it within the spreadsheet.

This methodology offers you a clear picture of your chart that may be inserted right into a PowerPoint presentation, Canva doc, or some other visible template.

To avoid wasting your Excel graph as a photograph, right-click on the graph and choose Save as Image.

Within the dialogue field, title the picture of your graph, select the place to put it aside in your pc, and select the file kind you’d like to put it aside as. On this instance, it’s saved as a JPEG to a desktop folder. Lastly, click on Save.

You’ll have a transparent picture of your graph or chart that you would be able to add to any visible design.

Visualize Knowledge Like A Professional

Prepared for one ultimate step to make this complete course of sooner? Now you can swap your knowledge into numerous graph sorts — like a pie chart or line graph — to shortly and extra simply decide what format greatest tells the story of your knowledge.

Right here’s the way you do it:

Step 1. Choose the chart.

Take a look at your Excel chart or graph to discover a clean spot inside it. Click on on a clean spot. As soon as the chart is highlighted throughout the border, you’ll comprehend it’s chosen.

Step 2. Proper-click or go to the Chart Design tab.

As soon as the chart is chosen, the ribbon above will present a Chart Design tab. You may go click on on that or just right-click your chosen chart to save lots of time. Both manner, you’ll see numerous chart choices to select from.

Step 3. Change the chart kind.

When the chart choices pop up — both on the ribbon or beneath your cursor in the event you right-clicked — you’ll subsequent click on Change Chart Kind. A menu will pop up with quite a lot of chart kind choices on the left.

To the suitable might be a visible instance of the chart kind you click on on.

Step 4. Store in your chart.

The final bit is essentially the most enjoyable! You may click on the Really helpful Charts tab or the All Charts tab and begin clicking your manner down the checklist of chart sorts. As you see ones that curiosity you, click on the Okay button.

Your initially chosen chart will change sorts earlier than your eyes. Give it a glance and ensure all the information and labels make sense to you. Nonetheless curious?

Choose your chart once more and repeat the method to see your knowledge on as many kinds of charts as you’d like.

No sorcery, as promised. Preserve these step-by-step tutorials helpful. You’ll be capable of create charts and graphs that shortly, cleanly, and clearly visualize your knowledge for presentation.

Editor’s observe: This submit was initially printed in June 2018 and has been up to date for comprehensiveness.