I nonetheless bear in mind being tremendous intimidated when requested to create a graph in Excel for a consumer‘s month-to-month report. It was my first day at work.
I didn’t wish to ask anybody for assist, however I needed to do a incredible job. So, I fastidiously (and discreetly) adopted the steps from totally different sources on the best way to create a graph in Excel.
![Download 10 Excel Templates for Marketers [Free Kit]](https://no-cache.hubspot.com/cta/default/53/9ff7a4fe-5293-496c-acca-566bc6e73f42.png)
Since then, I’ve experimented a zillion instances and crafted totally different variations of graphs and charts in Excel that look tremendous polished.
My takeaway? Having an outlined course of all the time helps. So, I now have a go-to, step-by-step course of I swear by when creating Excel charts and graphs.
So you’ve got one too, I’ve compiled an in depth, actionable information that can assist you visualize knowledge in Excel like a professional. Observe it, and creating graphs and charts in Excel will change into your second nature.
Desk of Contents
What’s an Excel chart or graph?
An Excel chart or graph is a visible illustration of a Microsoft Excel worksheet’s knowledge. These graphs and charts help you see traits, make comparisons, pinpoint patterns, and glean insights from inside the uncooked numbers. Excel contains numerous choices for charts and graphs, together with bar, line, and pie charts.
However why visualize in Excel when you’ll be able to merely clarify the numbers? This was my first thought after I was requested to create the graph.
I’ve discovered that including Excel charts helps the viewers perceive and retain the related findings a lot better.
Presenting knowledge as a graph makes data visually digestible and helps talk clearly and effectively, particularly for big knowledge units.
(I’ve seen this firsthand a thousand instances when knowledge from instruments like SEMrush, Ahrefs, and extra.)
Furthermore, when the information has multiple discovering to speak — resembling a comparability or modifications happening over time — Excel charts and graphs provide a number of choices for creating impactful visuals.
The way to Create a Graph in Excel
- Enter your knowledge into Excel.
- Select your graph or chart kind.
- Spotlight knowledge and insert your graph.
- Swap your axes if wanted.
- Customise colours and structure.
- Modify label sizes.
- Refine Y-axis measurements.
- Reorder your knowledge.
- Add a compelling title.
- Export your graph like a professional.
Making a graph in Excel is easy. Observe my step-by-step course of or obtain the PDF directions beneath:
Many of the buttons and features you will see and browse are very comparable throughout all variations of Excel. Don’t wish to begin from scratch and like one thing faster to repair as an alternative? You may leverage Excel Graph Turbines.
Simply plug in your knowledge, tweak the design, and also you’ll get a professional-looking graph with minimal effort. I swear by this when time is tight. However I am going by the whole course of after I need or want one thing totally custom-made.
Let me stroll you thru my steps.
1. Enter your knowledge into Excel.
So, I begin by plugging in my knowledge, which I set up into columns and rows. That is fundamental, nevertheless it’s all that you must begin.
Whether or not you’re importing knowledge from a survey device, downloading it out of your advertising and marketing platform, or just typing it in manually, the first step is set up.
Let me present you a fast instance of how I set up my knowledge.
Let’s say we’re visualizing advertising and marketing ROI.
As you’ll be able to see within the spreadsheet above, I’ve organized it as follows:
- Column A lists responses to the query, “Did inbound advertising and marketing display ROI?” or “Couldn’t or didn’t calculate ROI?”
- Columns B and C record responses detailing whether or not or not the corporate had a proper sales-marketing settlement.
So, as per my knowledge association, Column B, Row 2 illustrates that 49% of individuals with a service stage settlement (SLA) additionally say that inbound advertising and marketing demonstrated ROI.
2. Select your graph or chart kind.
As soon as my knowledge is in and arranged, I select my most well-liked graph type. Excel affords many choices, together with bar charts, line graphs, pie charts, scatter plots, and extra.
I select the kind that greatest tells my story. For instance, when evaluating issues, I am going for bar graphs. When emphasizing percentages or scatter plots for traits, I have a tendency to make use of pie charts.
There’s no arduous and quick rule right here. I’d say, think about your viewers and whether or not you wish to preserve it easy or add a inventive aptitude. (Extra on this beneath.)
3. Spotlight knowledge and insert your graph.
As soon as I’ve organized my knowledge and selected my chart kind, I spotlight the cells I wish to visualize (together with the headers). Subsequent, I click on on the Insert tab and choose the chart kind I’ve selected within the earlier step.
I’ve chosen a clear, two-dimensional column chart right here as a result of flat bars look sharp {and professional}. See beneath:
However hey, this isn’t all the time set in stone. I additionally typically customise based mostly on the viewers.
For instance, I as soon as used a three-dimensional chart to imitate skyscrapers when creating charts for a development consumer. This made the information visually related and memorable, they usually liked it.
Working example: Small tweaks go a good distance.
4. Swap your axes if wanted.
Generally, after inserting my graph, I really feel the X and Y axes could have to be swapped for readability. When this occurs, I right-click on the graph, choose Choose Information, and hit the Swap Row/Column button.
Let me clarify this extra by revisiting the SLA knowledge instance.
So, the primary orientation labored nice for normal audiences. Nonetheless, if my presentation was all about SLAs and I have been to current it to a room filled with executives targeted on deciding whether or not or to not safe one, I’d favor to flip.
I’d go for the second XY orientation to create one thing just like the one beneath.
Do you now see the distinction in readability with this one easy change?
5. Customise colours and structure.
That is one in all my favourite components, the place I can let my creativity unfastened and decide and select between colours and structure. And belief me, these particulars matter.
I normally use softer tones for inner shows and daring, branded colours for exterior audiences. I additionally go the additional mile for key purchasers and customise the bar colours to match their model palette, immediately making the chart extra skilled.
I’ve seen this make an enduring impression.
To customise, I click on on the chart and discover the Chart Design tab to regulate layouts, colours, and legend placement.
After I wish to format the legend additional, I click on on it and hover over the Format Legend Entry sidebar, as proven beneath.
Right here, I modify the fill shade of the legend to alter the colour of the columns as I would like it. Generally, I additionally format different components of my chart. For that, I click on on them individually to disclose a corresponding Format window.
6. Modify label sizes.
Small labels can wreck an incredible graph. I all the time examine and bump the font dimension for axis and legend labels at any time when wanted. This ensures they’re all the time legible, particularly whereas presenting them.
To do that, I click on on the label, go to the House tab, and modify the font dimension. It is a easy step, however once more, it makes an enormous distinction. See beneath:
7. Refine Y-axis measurements.
I’ve typically encountered conditions the place Excel’s default Y-axis doesn’t minimize it, and decoding the information turns into complicated.
In these conditions, I customise my Y-axis measurements. To do that, I click on on the Y-axis percentages in my chart, which reveals the Format Axis window.
Right here, I determine whether or not to show models on the Axis Choices tab and whether or not to point out percentages to 2 or no decimal locations on my Y-axis.
As you’ll be able to see, my graph routinely units the Y axis’ most proportion to 60%. After I wish to change it manually to 100% to symbolize knowledge on a common scale, I choose the Most choice (that is two fields down below Bounds within the Format Axis window).
Right here, I’ve modified the worth from 0.6 to 1. This offers a ensuing graph just like the one beneath:
PS: On this instance, I’ve additionally elevated the font dimension of the Y-axis by way of the House tab so as to see the distinction.
8. Reorder your knowledge.
Generally, I really feel it might be higher if my knowledge seems in reverse order.
After I wish to kind it that means, I right-click on the graph and click on Choose Information to disclose the identical choices window as in Step 3 above. To reorder, I select the arrow up or right down to reverse the order of my knowledge on the chart.
Re-arranging in ascending or descending order is feasible even when there are greater than two strains of information to regulate. After I wish to do that, I spotlight all of my knowledge within the cells above my chart, click on Information, and choose Kind, as proven beneath.
Relying on my choice, I select to kind based mostly on the smallest to largest or vice versa. The ensuing graph appears to be like one thing just like the one beneath.
It is tremendously higher, proper? As you’ll be able to see, this model displays the development of outcomes and is far more visually persuasive.
9. Add a compelling title.
The title is your graph’s headline — and I strongly really feel you’ve bought to make it rely. So as to add a title, I click on on the default Chart Title to disclose a typing cursor. Then, I change it with one thing particular and interesting.
As soon as I’ve crammed in what I like, I click on House on the highest navigation bar and use the font formatting choices to present my title the emphasis it deserves.
See these choices and my last graph beneath:
10. Export your graph like a professional.
Voila! We’re practically achieved and have a tremendous graph.
My subsequent step? I positively gained’t screenshot it. As a substitute, I’ll right-click on the chart and choose Save as Image. This may give me a clear, high-quality picture that I can now use for shows, Canva graphics, and social media posts.
As proven within the picture beneath, a dialogue field will seem so as to add the file title, location, and kind whereas saving. I’ve saved this instance as a JPEG in my desktop folder.
To date so good? As soon as I’ve bought any chart prepared, I typically mess around a bit extra. I experiment with differing types to current my story within the best-suited method. Let me take you thru how I try this.
Visualize Information Like a Professional: The way to Experiment With Chart Sorts
My favourite a part of working with Excel knowledge is deciding the best way to current it visually.
Generally, I begin out pondering a bar graph will do the trick. Nonetheless, after experimenting, I understand a pie chart or line graph would inform the story higher, so I swap it.
PS: Each time I do that, I’m reminded how a lot the best graph can elevate the presentation.
Swapping chart varieties in Excel is easy. Right here’s exactly how I strategy it.
Step 1: Choose the chart.
First, I click on on a clean space of my chart to pick out it. As soon as I see the border mild up across the chart, I do know it’s prepared for edits. This ensures that no matter modifications I make apply to the entire graph, not only a particular label or axis.
Step 2: Open the chart design tab.
Subsequent, I head to the ribbon and click on the Chart Design tab. Generally, I take the sooner route and simply right-click on the chart to tug up the identical choices. It’s a bit of trick I’ve picked as much as save time, and it really works each time.
Step 3: Change the chart kind.
Right here’s the place issues begin to get enjoyable.
I click on Change Chart Sort, and Excel exhibits me all my choices on the left-hand facet. Bar charts, pie charts, scatter plots — you title it, and it’s there. On the best, a helpful preview lets me see how every chart kind would look with my knowledge.
On this step, I take into consideration the story I’m attempting to inform and make my selection. For instance, if I wish to emphasize proportions, I could use a pie chart. If I wish to present traits over time, I could use a line graph.
Step 4: Store for the very best match.
This half appears like window buying (I’ll admit, I’ve spent extra time right here than I care to confess.) I scroll by the Really helpful Charts and All Charts tabs, clicking by choices and seeing how my knowledge transforms.
As soon as I discover a chart kind that works — one thing clear, clear, and aligned with my viewers’s wants — I hit OK. Watching the graph change immediately is all the time satisfying and infrequently sparks new concepts for presenting my insights!
As I’ve shared my steps with you, I am positive you might need puzzled sooner or later what components ought to go into selecting the suitable chart or graph to your challenge.
So, let’s chat charts now and offer you concepts about which charts might show you how to inform the tales in your knowledge.
The 18 Forms of Charts in Excel
Understanding the makes use of of various chart varieties in Excel can put you at an edge in optimizing the way you current data. This may be extremely worthwhile and insightful to your staff’s initiatives.
Within the following part, I’ll share my favourite tried-and-tested choices. Then, on the finish, I’ll additionally briefly summarize the superior chart varieties and people who I really feel will not be as helpful to entrepreneurs from my expertise.
Excel Charts Most Helpful to Entrepreneurs
1. Space Chart
Excel space charts help you see traits over time or different related variables. They’re primarily a line graph with colored-in sections emphasizing development and giving a way of quantity.
Then, there are stacked space charts. These denser space charts help you present extra data without delay, resembling evaluating traits in a number of classes or monitoring modifications throughout totally different variables.
Greatest for: Demonstrating the magnitude of a development between two or extra values over a given interval.
2. Clustered Bar Graph
An Excel bar graph represents data horizontally and compares totally different knowledge sequence. It permits you to simply see the proportions between varied classes or parts of your knowledge.
As an illustration, you need to use clustered bar graphs to match the gross sales by totally different brokers throughout places. This might help you perceive how totally different brokers carry out throughout geographies in the identical time-frame.
Greatest for: Evaluating the frequency of comparable values between totally different variables.
3. Clustered Column Charts
Column charts are much like bar graphs, however they differ in a single important means: they’re vertical, not horizontal. The vertical orientation helps viewers rank totally different knowledge parts.
Like bar graphs, column charts evaluate knowledge, show traits, and present proportions. As an illustration, if you wish to rank your gross sales brokers conversion numbers and think about it throughout totally different places.
You may visualize them in a clustered column chart and see which agent performs greatest in a specific location. This might be seen because the tallest in that cluster.
Greatest for: Displaying varied knowledge parts to rank them visually over time.
Professional tip: I’ve seen firsthand how column charts displaying T-bars of statistical significance are extraordinarily helpful in serving to individuals in management dispel possible however in the end unfaithful interpretations of information.
Generally, knowledge exhibiting significant change remains to be inside regular parameters. Generally, a slight distinction is important. Managers and administrators could need assistance seeing these realities so that they don’t oversteer at determination time.
4. Line Graph
A line graph is an easy however extremely efficient solution to visually see traits over time — even with out the frills of bars, columns, or additional shading. You can even evaluate a number of knowledge sequence.
As you’ll be able to see within the graph above, the road graph compares modifications in inhabitants over time for bears, dolphins, and whales.
This has thrilling purposes within the advertising and marketing context. As an illustration, you need to use it to visualise the variety of natural visits from Google versus Bing over 12 months. You can even see the speed or pace at which your knowledge set modifications.
Within the Google vs. Bing instance, a steep incline would imply a sudden spike in natural site visitors, whereas a extra gradual decline might imply site visitors is reducing slowly.
Greatest for: Illustrating traits over time, resembling spikes or drops in gross sales resulting from holidays, climate, or different variables.
5. Pie Chart
A pie chart is a useful means of seeing how totally different knowledge parts proportionally evaluate, resembling gross sales throughout months, as proven within the chart above.
Like line graphs, that is additionally extensively utilized in advertising and marketing. Let’s say you’re curious in regards to the proportion of your natural site visitors from Google versus Bing. Or how a lot market share do you’ve got in comparison with rivals?
A pie chart is usually a becoming solution to visualize that data. It’s additionally a good way to see and talk progress towards a particular objective. As an illustration, in case your objective is to promote a product every single day for 30 days in a row, you then may create a pie chart with 30 slices and shade a slice every day you promote the product.
Greatest for: Exhibiting values as percentages of an entire and viewing knowledge parts proportionately.
6. Radar Chart
A radar chart may look acquainted to you should you’ve ever taken a persona check, nevertheless it’s additionally helpful outdoors of that trade.
Radar charts show knowledge in a closed, multi-pointed form. Every level known as a spoke, and a number of variables “pull” spokes of the form. Then, shapes may be stacked up for comparability.
Any such chart is well-designed for evaluating totally different knowledge parts, resembling attributes, entities, individuals, strengths, or weaknesses. It additionally helps you see the distribution of your knowledge and perceive whether or not it is overly skewed.
Greatest for: Evaluating the combination values of a number of knowledge sequence without delay.
7. Scatter Plot
Scatter plots look much like line graphs however with one important distinction: They consider the connection between two variables proven on the X- and Y-axes, enabling you to determine correlations and patterns between them. The scatter plot within the graph above denotes the correlation between age and time.
Within the advertising and marketing context, you need to use scatters in situations like evaluating the quantity of natural site visitors (X-axis) with the variety of leads and signups (Y-axis).
For those who see an upward development within the dots the place these two converge, you’ll understand how a rise in natural site visitors impacts your leads and signups.
You probably have a leads/signups objective, you’ll be able to create a extra data-driven plan for growing natural site visitors.
You may even additional evaluate the variety of leads and signups with day by day gross sales or conversions to maintain extra applications on data-driven paths.
Greatest for: Visualizing constructive or unfavorable relationships between two variables.
8. Funnel Chart
Funnel charts are extremely well-suited to entrepreneurs who wish to optimize processes and pipelines.
Within the picture above, it’s clear that you simply drop probably the most candidates between the phases Certified Prospects and Wants Evaluation. So, it might be fascinating to look at that portion of your funnel extra deeply to grasp why.
Greatest for: Visually representing modifications by processes helps to make clear the place the most important modifications happen alongside the best way.
Professional tip: My expertise has taught me that should you solely use two ranges — particularly if there’s no nice change between them, it’s straightforward to mistake this for a bar graph, which features fully in another way. You’ll wish to use not less than three ranges so it’s extra clearly distinguished as a funnel form.
9. Histogram Chart
Histograms are a strong choice when explaining knowledge that happens most usefully in ranges. As an illustration, the graph above exhibits the variety of occurrences of a specific occasion, in contrast throughout temperature ranges.
In advertising and marketing, you need to use it for purposes like exhibiting your purchasers the shopping for habits of assorted age demographics of their product area of interest. Chances are you’ll discover that the target market has moved, probably even jumped a variety up or down.
If the consumer has offered child merchandise for the final 100 years, you’d see that their target market of first-time dad and mom is getting older as individuals wait longer to have kids.
This will likely change your advertising and marketing methods to satisfy the wants and problems with this older first-time guardian demographic.
Greatest for: Demonstrating knowledge findings which might be most noticeable and helpful when the information is grouped in ranges.
Superior Excel Charts
Excel additionally has superior charts which might be extra difficult and higher suited to audiences who can already learn advanced-level charts. A few of these embody:
10. Field and whisker chart.
11. Pareto chart.
12. Floor chart.
13. Sunburst chart.
14. Treemap chart.
Trade-Particular Excel Charts
The remaining Excel chart varieties don’t usually lend themselves to advertising and marketing. However, hey — in case your area of interest requires it, these charts listed beneath are there to help you:
15. Inventory chart.
16. Waterfall chart.
17. Crammed map chart.
18. Combo chart.
Summarizing the Charts
I do know this has been a ton of data. For those who’re nonetheless uncertain which to decide on, right here’s a concise comparability of the Excel charts I discover most useful to entrepreneurs.
|
kind of chart |
Use |
|
Space |
Space charts display the magnitude of a development between two or extra values over a given interval. |
|
ClusteredBar |
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 frame to visualise rank amongst knowledge units. |
|
Line |
Much like bar charts, they illustrate traits over time. |
|
Pie |
Pie charts present values as percentages of an entire. |
|
Radar |
Radar charts evaluate the combination worth of a number of knowledge sequence. |
|
Scatter |
Scatter charts present the constructive or unfavorable relationship between two variables. |
|
Funnel |
Funnel charts excel at visualizing modifications to 1 knowledge level over varied processes. |
|
Histogram |
Histograms present variations in knowledge which might be greatest represented as a variety of values. |
Aspect quest: For those who’re searching for a deeper dive that can assist you work out which kind of chart/graph is greatest for visualizing your knowledge, take a look at this free book, The way to Use Information Visualization to Win Over Your Viewers.
Excel Charting Journey: Confidence and Mastery Await
Trying again on that first day after I scrambled to make my graph, I’m amazed at how far I’ve are available in creating graphs and charts in Excel.
My journey has made me understand that charting successfully is just not about perfection — it is about course of. Now, with a transparent, step-by-step strategy, constructing charts has change into my second nature.
Whether or not you‘re simply beginning or refining your expertise, keep in mind that each graph you create will add to your experience. Don’t be afraid to experiment, modify, and make errors.
Excel affords countless potentialities to inform tales by knowledge — so belief the method, have enjoyable with it, and watch your expertise develop. You’ve bought this!
Editor’s word: This submit was initially printed in April 2013 and has been up to date for comprehensiveness.
