I still remember being super intimidated when asked to create a graph in Excel for a client\u2018s monthly report. It was my first day at work.<\/p>\n\n
I didn\u2019t want to ask anyone for help, but I wanted to do a fantastic job. So, I carefully (and discreetly) followed the steps from different sources on how to create a graph in Excel.<\/p>\n
<\/a><\/p>\n Since then, I\u2019ve experimented a zillion times and crafted different variations of graphs and charts in Excel that look super polished.<\/p>\n My takeaway? Having a defined process always helps. So, I now have a go-to, step-by-step process I swear by when creating Excel charts and graphs.<\/p>\n So you have one too, I\u2019ve compiled a detailed, actionable guide to help you visualize data in Excel like a pro. Follow it, and creating graphs and charts in Excel will become your second nature.<\/p>\n Table of Contents<\/strong><\/p>\n What is an Excel chart or graph?<\/a> <\/a> <\/p>\n But why visualize in Excel when you can simply explain the numbers? This was my first thought when I was asked to create the graph.<\/p>\n I\u2019ve learned that adding Excel charts helps the audience understand and retain the relevant findings much better.<\/p>\n Presenting data as a graph makes information visually digestible and helps communicate clearly and efficiently<\/span>, especially for large data sets.<\/p>\n (I\u2019ve seen this firsthand a thousand times when looking at data from tools like SEMrush, Ahrefs, and more.)<\/p>\n Moreover, when the data has more than one finding to communicate \u2014 such as a comparison or changes taking place over time \u2014 Excel charts and graphs offer several options for creating impactful visuals.<\/p>\n <\/a> <\/p>\n Creating a graph in Excel is simple. Follow my step-by-step process or download the PDF instructions below:<\/p>\n Download Demo Data<\/a> Most of the buttons and functions you’ll see and read are very similar across all versions of Excel. Don\u2019t want to start from scratch and prefer something quicker to fix instead? You can leverage Excel Graph Generators.<\/a><\/p>\n Just plug in your data, tweak the design, and you\u2019ll get a professional-looking graph with minimal effort. I swear by this when time is tight. But I go through the entire process when I want or need something fully customized.<\/p>\n Let me walk you through my steps.<\/p>\n So, I start by plugging in my data, which I organize into columns and rows. This is basic, but it’s all you need to start.<\/p>\n Whether you\u2019re importing data from a survey tool, downloading it from your marketing platform<\/a>, or simply typing it in manually, step one is organize.<\/p>\n Let me show you a quick example of how I organize my data.<\/p>\n Let\u2019s say we\u2019re visualizing marketing ROI.<\/p>\n\n As you can see in the spreadsheet above, I\u2019ve organized it as follows:<\/p>\n Column A lists responses to the question, \u201cDid inbound marketing demonstrate ROI?\u201d or \u201cCould not or did not calculate ROI?\u201d So, as per my data arrangement, Column B, Row 2 illustrates that 49% of people with a service level agreement (SLA)<\/a> also say that inbound marketing demonstrated ROI.<\/p>\n Once my data is in and organized, I choose my preferred graph style. Excel offers many options, including bar charts, line graphs, pie charts, scatter plots, and more.<\/p>\n\n I choose the type that best tells my story. For example, when comparing things, I go for bar graphs. When emphasizing percentages or scatter plots for trends, I tend to use pie charts.<\/p>\n There\u2019s no hard and fast rule here. I\u2019d say, consider your audience and whether you want to keep it simple or add a creative flair. (More on this below.)<\/p>\n Once I\u2019ve organized my data and decided on my chart type, I highlight the cells I want to visualize (including the headers). Next, I click on the Insert<\/strong> tab and select the chart type I\u2019ve decided on in the previous step.<\/p>\n\n I\u2019ve chosen a clean, two-dimensional column chart here because flat bars look sharp and professional. See below:<\/p>\n\n But hey, this isn\u2019t always set in stone. I also sometimes customize based on the audience.<\/p>\n For example, I once used a three-dimensional chart to mimic skyscrapers when creating charts for a construction client. This made the data visually relevant and memorable, and they loved it.<\/p>\n Case in point: Small tweaks go a long way.<\/p>\n Sometimes, after inserting my graph, I feel the X and Y axes may need to be swapped for clarity. When this happens, I right-click on the graph, select Select<\/strong> Data<\/strong>, and hit the Switch Row\/Column<\/strong> button.<\/p>\n\n Let me explain this more by revisiting the SLA data example.<\/p>\n So, the first orientation worked great for general audiences. However, if my presentation was all about SLAs and I were to present it to a room full of executives focused on deciding whether or not to secure one, I\u2019d prefer to flip.<\/p>\n I\u2019d go for the second XY orientation to create something like the one below.<\/p>\n\n Do you now see the difference in clarity with this one simple change?<\/p>\n This is one of my favorite parts, where I can let my creativity loose and pick and choose between colors and layout. And trust me, these details matter.<\/p>\n I usually use softer tones for internal presentations and bold, branded colors for external audiences. I also go the extra mile for key clients and customize the bar colors to match their brand palette, instantly making the chart more professional.<\/p>\n I\u2019ve seen this make a lasting impression.<\/p>\n To customize, I click on the chart and explore the Chart<\/strong> Design<\/strong> tab to adjust layouts, colors, and legend placement.<\/p>\n\n When I want to format the legend further, I click on it and hover over the Format Legend Entry<\/strong> sidebar, as shown below.<\/p>\n\n Here, I change the fill color of the legend to change the color of the columns as I want it. Sometimes, I also format other parts of my chart. For that, I click on them individually to reveal a corresponding Format<\/strong> window.<\/p>\n Small labels can ruin a great graph. I always check and bump the font size for axis and legend labels whenever needed. This ensures they\u2019re always legible, especially while presenting them.<\/p>\n To do this, I click on the label, go to the Home tab, and adjust the font size. This is a simple step, but again, it makes a big difference. See below:<\/p>\n\n I\u2019ve often encountered situations where Excel\u2019s default Y-axis doesn\u2019t cut it, and interpreting the data becomes complex.<\/p>\n In those situations, I customize my Y-axis measurements. To do this, I click on the Y-axis percentages in my chart, which reveals the Format<\/strong> Axis<\/strong> window.<\/p>\n\n Here, I decide whether to display units on the Axis<\/strong> Options<\/strong> tab and whether to show percentages to two or no decimal places on my Y-axis.<\/p>\n As you can see, my graph automatically sets the Y axis’ maximum percentage to 60%. When I want to change it manually to 100% to represent data on a universal scale, I select the Maximum option (this is two fields down under Bounds in the Format Axis window).<\/p>\n Here, I\u2019ve changed the value from 0.6 to one. This gives a resulting graph like the one below:<\/p>\n\n PS: In this example, I\u2019ve also increased the font size of the Y-axis via the Home tab so that you can see the difference.<\/p>\n Sometimes, I feel it may be better if my data appears in reverse order.<\/p>\n When I want to sort it that way, I right-click on the graph and click Select<\/strong> Data<\/strong> to reveal the same options window as in Step 3 above. To reorder, I choose the arrow up or down to reverse the order of my data on the chart.<\/p>\n\n Re-arranging in ascending or descending order is possible even when there are more than two lines of data to adjust. When I want to do this, I highlight all of my data in the cells above my chart, click Data<\/strong>, and select Sort<\/strong>, as shown below.<\/p>\n\n Depending on my preference, I choose to sort based on the smallest to largest or vice versa. The resulting graph looks something like the one below.<\/p>\n\n It’s tremendously better, right? As you can see, this version reflects the progression of results and is much more visually persuasive.<\/p>\n The title is your graph\u2019s headline \u2014 and I strongly feel you\u2019ve got to make it count. To add a title, I click on the default Chart<\/strong> Title<\/strong> to reveal a typing cursor. Then, I replace it with something specific and engaging.<\/p>\n Once I\u2019ve filled in what I like, I click Home<\/strong> on the top navigation bar and use the font formatting options to give my title the emphasis it deserves.<\/p>\n See these options and my final graph below:<\/p>\n\n Voila! We\u2019re nearly done and have an amazing graph.<\/p>\n My next step? I definitely won\u2019t screenshot it. Instead, I\u2019ll right-click on the chart and select Save as Picture<\/strong>. This will give me a clean, high-quality image that I can now use for presentations, Canva graphics, and social media posts.<\/p>\n\n As shown in the image below, a dialogue box will appear to add the file name, location, and type while saving. I\u2019ve saved this example as a JPEG in my desktop folder.<\/p>\n\n So far so good? Once I\u2019ve got any chart ready, I often play around a bit more. I experiment with different types to present my story in the best-suited manner. Let me take you through how I do that.<\/p>\n <\/a> <\/p>\n My favorite part of working with Excel data is deciding how to present it visually.<\/p>\n Sometimes, I start out thinking a bar graph will do the trick. However, after experimenting, I realize a pie chart or line graph would tell the story better, so I swap it.<\/p>\n PS: Every time I do this, I\u2019m reminded how much the right graph can elevate the presentation.<\/p>\n Swapping chart types in Excel is simple. Here\u2019s precisely how I approach it.<\/p>\n First, I click on a blank area of my chart to select it. Once I see the border light up around the chart, I know it\u2019s ready for edits. This ensures that whatever changes I make apply to the whole graph, not just a specific label or axis.<\/p>\n Next, I head to the ribbon and click the Chart<\/strong> Design<\/strong> tab. Sometimes, I take the faster route and just right-click on the chart to pull up the same options. It\u2019s a little trick I\u2019ve picked up to save time, and it works every time.<\/p>\n Here\u2019s where things start to get fun.<\/p>\n I click Change Chart Type<\/strong>, and Excel shows me all my options on the left-hand side. Bar charts, pie charts, scatter plots \u2014 you name it, and it\u2019s there. On the right, a handy preview lets me see how each chart type would look with my data.<\/p>\n In this step, I think about the story I\u2019m trying to tell and make my choice. For example, if I want to emphasize proportions, I may use a pie chart. If I want to show trends over time, I may use a line graph.<\/p>\n This part feels like window shopping (I\u2019ll admit, I\u2019ve spent more time here than I care to admit.) I scroll through the Recommended<\/strong> Charts<\/strong> and All<\/strong> Charts<\/strong> tabs, clicking through options and seeing how my data transforms.<\/p>\n Once I find a chart type that works \u2014 something clean, clear, and aligned with my audience\u2019s needs \u2014 I hit OK<\/strong>. Watching the graph change instantly is always satisfying and often sparks new ideas for presenting my insights!<\/p>\n As I have shared my steps with you, I’m sure you might have wondered at some point what factors should go into choosing the appropriate chart or graph for your project.<\/p>\n So, let\u2019s chat charts now and give you ideas about which charts could help you tell the stories in your data.<\/p>\n <\/a> <\/p>\n Understanding the uses of different chart types in Excel can put you at an edge in optimizing how you present information. This can be highly valuable and insightful for your team\u2019s projects.<\/p>\n In the following section, I\u2019ll share my favorite tried-and-tested options. Then, at the end, I\u2019ll also briefly summarize the advanced chart types and those that I feel may not be as useful to marketers from my experience.<\/p>\n Excel area charts allow you to see trends over time or other relevant variables. They\u2019re essentially a line graph with colored-in sections emphasizing progression and giving a sense of volume.<\/p>\n Then, there are stacked area charts. These denser area charts allow you to show more information at once, such as comparing trends in multiple categories or tracking changes across different variables.<\/p>\n Best for:<\/strong> Demonstrating the magnitude of a trend between two or more values over a given period.<\/p>\n An Excel bar graph represents information horizontally and compares different data series. It allows you to easily see the proportions between various categories or elements of your data.<\/p>\n For instance, you can use clustered bar graphs to compare the sales by different agents across locations. This can help you understand how different agents perform across geographies in the same time frame.<\/p>\n Best for:<\/strong>\u00a0Comparing the frequency of similar values between different variables.<\/p>\n Source<\/a><\/em><\/p>\n Column charts are similar to bar graphs, but they differ in one critical way: they\u2019re vertical, not horizontal. The vertical orientation helps viewers rank<\/em> different data elements.<\/p>\n Like bar graphs, column charts compare data, display trends, and show proportions. For instance, if you want to rank your sales agents conversion numbers and view it across different locations.<\/p>\n You can visualize them in a clustered column chart and see which agent performs best in a particular location. This will be visible as the tallest in that cluster.<\/p>\n Best for:<\/strong> Displaying various data elements to rank them visually over time.<\/p>\n Pro tip:<\/strong> I\u2019ve seen firsthand how column charts displaying T-bars of statistical significance are extremely useful in helping people in leadership dispel likely but ultimately untrue interpretations of data.<\/p>\n Sometimes, data showing meaningful change is still within normal parameters. Sometimes, a slight difference is significant. Managers and directors may need help seeing these realities so they don\u2019t oversteer at decision time.<\/p>\n Source<\/a><\/em><\/p>\n A line graph is a simple but highly effective way to visually see trends over time \u2014 even without the frills of bars, columns, or extra shading. You can also compare multiple data series.<\/p>\n As you can see in the graph above, the line graph compares changes in population over time for bears, dolphins, and whales.<\/p>\n This has exciting applications in the marketing context. For instance, you can use it to visualize the number of organic visits from Google versus Bing over 12 months. You can also see the rate or speed at which your data set changes.<\/p>\n In the Google vs. Bing example, a steep incline would mean a sudden spike in organic traffic, whereas a more gradual decline could mean traffic is decreasing slowly.<\/p>\n Best for: <\/strong>Illustrating trends over time, such as spikes or drops in sales due to holidays, weather, or other variables.<\/p>\n Source<\/a><\/em><\/p>\n A pie chart is a helpful way of seeing how different data elements proportionally compare, such as sales across months, as shown in the chart above.<\/p>\n Like line graphs, this is also extensively used in marketing. Let\u2019s say you\u2019re curious about the percentage of your organic traffic from Google versus Bing. Or how much market share do you have compared to competitors?<\/p>\n A pie chart can be a fitting way to visualize that information. It\u2019s also a great way to see and communicate progress toward a specific goal. For instance, if your goal is to sell a product every day for 30 days in a row, then you might create a pie chart with 30 slices and shade a slice each day you sell the product.<\/p>\n Best for:<\/strong> Showing values as percentages of a whole and viewing data elements proportionately.<\/p>\n Source<\/a><\/em><\/p>\n A radar chart might look familiar to you if you\u2019ve ever taken a personality test, but it\u2019s also useful outside of that industry.<\/p>\n Radar charts display data in a closed, multi-pointed shape. Each point is called a spoke, and multiple variables \u201cpull\u201d spokes of the shape. Then, shapes can be stacked up for comparison.<\/p>\n This type of chart is well-designed for comparing different data elements, such as attributes, entities, people, strengths, or weaknesses. It also helps you see the distribution of your data and understand whether it’s overly skewed.<\/p>\n Best for:<\/span> Comparing the aggregate values of multiple data series at once.<\/p>\n Source<\/a><\/em><\/p>\n Scatter plots look similar to line graphs but with one critical difference: They evaluate the relationship between two variables shown on the X- and Y-axes, enabling you to identify correlations and patterns between them. The scatter plot in the graph above denotes the correlation between age and time.<\/p>\n In the marketing context, you can use scatters in scenarios like comparing the amount of organic traffic (X-axis) with the number of leads and signups (Y-axis).<\/p>\n If you see an upward trend in the dots where these two converge, you\u2019ll know how an increase in organic traffic affects your leads and signups.<\/p>\n If you have a leads\/signups goal, you can create a more data-driven plan for increasing organic traffic.<\/p>\n You can even further compare the number of leads and signups with daily sales or conversions to keep more programs on data-driven paths.<\/p>\n Best for: <\/strong>Visualizing positive or negative relationships between two variables.<\/p>\n Source<\/a><\/em><\/p>\n Funnel charts are incredibly well-suited to marketers who want to optimize processes and pipelines.<\/p>\n In the image above, it\u2019s clear that you drop the most candidates between the stages Qualified Prospects and Needs Analysis. So, it may be interesting to examine that portion of your funnel more deeply to understand why.<\/p>\n Best for:<\/strong> Visually representing changes through processes helps to clarify where the biggest changes occur along the way.<\/p>\n Pro tip: <\/strong>My experience has taught me that if you only use two levels \u2014 especially if there\u2019s no great change between them, it\u2019s easy to mistake this for a bar graph, which functions entirely differently. You\u2019ll want to use at least three levels so it\u2019s more clearly distinguished as a funnel shape.<\/p>\n Source<\/a><\/em><\/p>\n Histograms are a solid option when explaining data that occurs most usefully in ranges. For instance, the graph above shows the number of occurrences of a particular event, compared across temperature ranges.<\/p>\n In marketing, you can use it for applications like showing your clients the buying habits of various age demographics in their product niche. You may find that the target audience has moved, possibly even jumped a range up or down.<\/p>\n If the client has sold baby products for the last 100 years, you\u2019d see that their target audience of first-time parents is getting older as people wait longer to have children.<\/p>\n This may change your marketing strategies to meet the needs and issues of this older first-time parent demographic.<\/p>\n Best for: <\/strong>Demonstrating data findings that are most noticeable and useful when the data is grouped in ranges.<\/p>\n Excel also has advanced charts that are more complicated and better suited to audiences who can already read advanced-level charts. Some of these include:<\/p>\n 10. <\/strong>Box and whisker chart.<\/p>\n 11.<\/strong> Pareto chart.<\/p>\n 12.<\/strong> Surface chart.<\/p>\n 13.<\/strong> Sunburst chart.<\/p>\n 14.<\/strong> Treemap chart.<\/p>\n The remaining Excel chart types don\u2019t typically lend themselves to marketing. But, hey \u2014 if your niche calls for it, these charts listed below are there to support you:<\/p>\n 15.<\/strong> Stock chart.<\/p>\n 16.<\/strong> Waterfall chart.<\/p>\n 17<\/strong>. Filled map chart.<\/p>\n 18<\/strong>. Combo chart.<\/p>\n I know this has been a ton of information. If you\u2019re still unsure which to choose, here\u2019s a concise comparison of the Excel charts I find most helpful to marketers.<\/p>\n type of chart<\/span><\/p>\n Use<\/p>\n Area<\/strong><\/p>\n Area charts demonstrate the magnitude of a trend between two or more values over a given period.<\/p>\n Clustered<\/strong>Bar<\/strong><\/p>\n Clustered bar charts compare the frequency of values across different levels or variables.<\/p>\n Clustered <\/strong>Column<\/strong><\/p>\n Clustered column charts display data changes over a period of time to visualize rank among data sets.<\/p>\n Line<\/strong><\/p>\n Similar to bar charts, they illustrate trends over time.<\/p>\n Pie<\/strong><\/p>\n Pie charts show values as percentages of a whole.<\/p>\n Radar<\/strong><\/p>\n Radar charts compare the aggregate value of multiple data series.<\/p>\n Scatter<\/strong><\/p>\n Scatter charts show the positive or negative relationship between two variables.<\/p>\n Funnel<\/strong><\/p>\n Funnel charts excel at visualizing changes to one data point over various processes.<\/p>\n Histogram<\/strong><\/p>\n Histograms show variations in data that are best represented as a range of values.<\/p>\n Side quest: <\/strong>If you\u2019re looking for a deeper dive to help you figure out which type of chart\/graph is best for visualizing your data, check out this free ebook, How to Use Data Visualization to Win Over Your Audience<\/a>.<\/p>\n
\n How to Create a Graph in Excel<\/a>
\n Visualize Data Like a Pro: How to Experiment With Chart Types<\/a>
\n The 18 Types of Charts in Excel<\/a> <\/p>\n
\n Download Instructions (Mac)<\/a>
\n Download Instructions (PC)<\/a> <\/p>\n1. Enter your data into Excel.<\/h3>\n
\n Columns B and C list responses detailing whether or not the company had a formal sales-marketing agreement. <\/p>\n2. Choose your graph or chart type.<\/h3>\n
3. Highlight data and insert your graph.<\/h3>\n
4. Switch your axes if needed.<\/h3>\n
5. Customize colors and layout.<\/h3>\n
6. Adjust label sizes.<\/h3>\n
7. Refine Y-axis measurements.<\/h3>\n
8. Reorder your data.<\/h3>\n
9. Add a compelling title.<\/h3>\n
10. Export your graph like a pro.<\/h3>\n
Visualize Data Like a Pro: How to Experiment With Chart Types<\/h2>\n
Step 1: Select the chart.<\/h3>\n
Step 2: Open the chart design tab.<\/h3>\n
Step 3: Change the chart type.<\/h3>\n
Step 4: Shop for the best fit.<\/h3>\n
The 18 Types of Charts in Excel<\/h2>\n
Excel Charts Most Useful to Marketers<\/h3>\n
1. Area Chart<\/h4>\n\n
2. Clustered Bar Graph<\/h4>\n\n
3. Clustered Column Charts<\/h4>\n\n
4. Line Graph<\/h4>\n\n
5. Pie Chart<\/h4>\n\n
6. Radar Chart<\/h4>\n\n
7. Scatter Plot<\/h4>\n\n
8. Funnel Chart<\/h4>\n\n
9. Histogram Chart<\/h4>\n\n
Advanced Excel Charts<\/h3>\n
Industry-Specific Excel Charts<\/h3>\n
Summarizing the Charts<\/h3>\n
![Source<\/a><\/em><\/p>\nA pie chart is a helpful way of seeing how different data elements proportionally compare, such as sales across months, as shown in the chart above.<\/p>\nLike line graphs, this is also extensively used in marketing. Let\u2019s say you\u2019re curious about the percentage of your organic traffic from Google versus Bing. Or how much market share do you have compared to competitors?<\/p>\nA pie chart can be a fitting way to visualize that information. It\u2019s also a great way to see and communicate progress toward a specific goal. For instance, if your goal is to sell a product every day for 30 days in a row, then you might create a pie chart with 30 slices and shade a slice each day you sell the product.<\/p>\nBest for:<\/strong> Showing values as percentages of a whole and viewing data elements proportionately.<\/p>\n6. Radar Chart<\/h4>\n\nSource<\/a><\/em><\/p>\nA radar chart might look familiar to you if you\u2019ve ever taken a personality test, but it\u2019s also useful outside of that industry.<\/p>\nRadar charts display data in a closed, multi-pointed shape. Each point is called a spoke, and multiple variables \u201cpull\u201d spokes of the shape. Then, shapes can be stacked up for comparison.<\/p>\nThis type of chart is well-designed for comparing different data elements, such as attributes, entities, people, strengths, or weaknesses. It also helps you see the distribution of your data and understand whether it’s overly skewed.<\/p>\nBest for:<\/span> Comparing the aggregate values of multiple data series at once.<\/p>\n7. Scatter Plot<\/h4>\n\nSource<\/a><\/em><\/p>\nScatter plots look similar to line graphs but with one critical difference: They evaluate the relationship between two variables shown on the X- and Y-axes, enabling you to identify correlations and patterns between them. The scatter plot in the graph above denotes the correlation between age and time.<\/p>\nIn the marketing context, you can use scatters in scenarios like comparing the amount of organic traffic (X-axis) with the number of leads and signups (Y-axis).<\/p>\nIf you see an upward trend in the dots where these two converge, you\u2019ll know how an increase in organic traffic affects your leads and signups.<\/p>\nIf you have a leads\/signups goal, you can create a more data-driven plan for increasing organic traffic.<\/p>\nYou can even further compare the number of leads and signups with daily sales or conversions to keep more programs on data-driven paths.<\/p>\nBest for: <\/strong>Visualizing positive or negative relationships between two variables.<\/p>\n8. Funnel Chart<\/h4>\n\nSource<\/a><\/em><\/p>\nFunnel charts are incredibly well-suited to marketers who want to optimize processes and pipelines.<\/p>\nIn the image above, it\u2019s clear that you drop the most candidates between the stages Qualified Prospects and Needs Analysis. So, it may be interesting to examine that portion of your funnel more deeply to understand why.<\/p>\nBest for:<\/strong> Visually representing changes through processes helps to clarify where the biggest changes occur along the way.<\/p>\nPro tip: <\/strong>My experience has taught me that if you only use two levels \u2014 especially if there\u2019s no great change between them, it\u2019s easy to mistake this for a bar graph, which functions entirely differently. You\u2019ll want to use at least three levels so it\u2019s more clearly distinguished as a funnel shape.<\/p>\n9. Histogram Chart<\/h4>\n\nSource<\/a><\/em><\/p>\nHistograms are a solid option when explaining data that occurs most usefully in ranges. For instance, the graph above shows the number of occurrences of a particular event, compared across temperature ranges.<\/p>\nIn marketing, you can use it for applications like showing your clients the buying habits of various age demographics in their product niche. You may find that the target audience has moved, possibly even jumped a range up or down.<\/p>\nIf the client has sold baby products for the last 100 years, you\u2019d see that their target audience of first-time parents is getting older as people wait longer to have children.<\/p>\nThis may change your marketing strategies to meet the needs and issues of this older first-time parent demographic.<\/p>\nBest for: <\/strong>Demonstrating data findings that are most noticeable and useful when the data is grouped in ranges.<\/p>\nAdvanced Excel Charts<\/h3>\nExcel also has advanced charts that are more complicated and better suited to audiences who can already read advanced-level charts. Some of these include:<\/p>\n10. <\/strong>Box and whisker chart.<\/p>\n11.<\/strong> Pareto chart.<\/p>\n12.<\/strong> Surface chart.<\/p>\n13.<\/strong> Sunburst chart.<\/p>\n14.<\/strong> Treemap chart.<\/p>\nIndustry-Specific Excel Charts<\/h3>\nThe remaining Excel chart types don\u2019t typically lend themselves to marketing. But, hey \u2014 if your niche calls for it, these charts listed below are there to support you:<\/p>\n15.<\/strong> Stock chart.<\/p>\n16.<\/strong> Waterfall chart.<\/p>\n17<\/strong>. Filled map chart.<\/p>\n18<\/strong>. Combo chart.<\/p>\nSummarizing the Charts<\/h3>\nI know this has been a ton of information. If you\u2019re still unsure which to choose, here\u2019s a concise comparison of the Excel charts I find most helpful to marketers.<\/p>\ntype of chart<\/span><\/p>\nUse<\/p>\nArea<\/strong><\/p>\nArea charts demonstrate the magnitude of a trend between two or more values over a given period.<\/p>\nClustered<\/strong>Bar<\/strong><\/p>\nClustered bar charts compare the frequency of values across different levels or variables.<\/p>\nClustered <\/strong>Column<\/strong><\/p>\nClustered column charts display data changes over a period of time to visualize rank among data sets.<\/p>\nLine<\/strong><\/p>\nSimilar to bar charts, they illustrate trends over time.<\/p>\nPie<\/strong><\/p>\nPie charts show values as percentages of a whole.<\/p>\nRadar<\/strong><\/p>\nRadar charts compare the aggregate value of multiple data series.<\/p>\nScatter<\/strong><\/p>\nScatter charts show the positive or negative relationship between two variables.<\/p>\nFunnel<\/strong><\/p>\nFunnel charts excel at visualizing changes to one data point over various processes.<\/p>\nHistogram<\/strong><\/p>\nHistograms show variations in data that are best represented as a range of values.<\/p>\nSide quest: <\/strong>If you\u2019re looking for a deeper dive to help you figure out which type of chart\/graph is best for visualizing your data, check out this free ebook, How to Use Data Visualization to Win Over Your Audience<\/a>.<\/p>\n<\/a> <\/p>\nExcel Charting Adventure: Confidence and Mastery Await<\/h2>\nLooking back on that first day when I scrambled to make my graph, I\u2019m amazed at how far I\u2019ve come in creating graphs and charts in Excel.<\/p>\nMy journey has made me realize that charting effectively is not about perfection \u2014 it’s about process. Now, with a clear, step-by-step approach, building charts has become my second nature.<\/p>\nWhether you\u2018re just starting or refining your skills, remember that every graph you create will add to your expertise. Don\u2019t be afraid to experiment, adjust, and make mistakes.<\/p>\nExcel offers endless possibilities to tell stories through data \u2014 so trust the process, have fun with it, and watch your skills grow. You\u2019ve got this!<\/p>\nEditor’s note: This post was originally published in April 2013 and has been updated for comprehensiveness.<\/em><\/p>","protected":false},"excerpt":{"rendered":"I still remember being super intimidated when asked to create a graph in Excel for […]<\/p>\n","protected":false},"author":0,"featured_media":722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":0,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/media\/722"}],"wp:attachment":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/www.got-it.ai\/solutions\/excel-chat\/wp-content\/uploads\/2019\/03\/Figure-1-How-to-Create-a-Pie-Chart-from-a-Pivot-Table.png\"){kind=link}
![Source<\/a><\/em><\/p>\nA radar chart might look familiar to you if you\u2019ve ever taken a personality test, but it\u2019s also useful outside of that industry.<\/p>\nRadar charts display data in a closed, multi-pointed shape. Each point is called a spoke, and multiple variables \u201cpull\u201d spokes of the shape. Then, shapes can be stacked up for comparison.<\/p>\nThis type of chart is well-designed for comparing different data elements, such as attributes, entities, people, strengths, or weaknesses. It also helps you see the distribution of your data and understand whether it’s overly skewed.<\/p>\nBest for:<\/span> Comparing the aggregate values of multiple data series at once.<\/p>\n7. Scatter Plot<\/h4>\n\nSource<\/a><\/em><\/p>\nScatter plots look similar to line graphs but with one critical difference: They evaluate the relationship between two variables shown on the X- and Y-axes, enabling you to identify correlations and patterns between them. The scatter plot in the graph above denotes the correlation between age and time.<\/p>\nIn the marketing context, you can use scatters in scenarios like comparing the amount of organic traffic (X-axis) with the number of leads and signups (Y-axis).<\/p>\nIf you see an upward trend in the dots where these two converge, you\u2019ll know how an increase in organic traffic affects your leads and signups.<\/p>\nIf you have a leads\/signups goal, you can create a more data-driven plan for increasing organic traffic.<\/p>\nYou can even further compare the number of leads and signups with daily sales or conversions to keep more programs on data-driven paths.<\/p>\nBest for: <\/strong>Visualizing positive or negative relationships between two variables.<\/p>\n8. Funnel Chart<\/h4>\n\nSource<\/a><\/em><\/p>\nFunnel charts are incredibly well-suited to marketers who want to optimize processes and pipelines.<\/p>\nIn the image above, it\u2019s clear that you drop the most candidates between the stages Qualified Prospects and Needs Analysis. So, it may be interesting to examine that portion of your funnel more deeply to understand why.<\/p>\nBest for:<\/strong> Visually representing changes through processes helps to clarify where the biggest changes occur along the way.<\/p>\nPro tip: <\/strong>My experience has taught me that if you only use two levels \u2014 especially if there\u2019s no great change between them, it\u2019s easy to mistake this for a bar graph, which functions entirely differently. You\u2019ll want to use at least three levels so it\u2019s more clearly distinguished as a funnel shape.<\/p>\n9. Histogram Chart<\/h4>\n\nSource<\/a><\/em><\/p>\nHistograms are a solid option when explaining data that occurs most usefully in ranges. For instance, the graph above shows the number of occurrences of a particular event, compared across temperature ranges.<\/p>\nIn marketing, you can use it for applications like showing your clients the buying habits of various age demographics in their product niche. You may find that the target audience has moved, possibly even jumped a range up or down.<\/p>\nIf the client has sold baby products for the last 100 years, you\u2019d see that their target audience of first-time parents is getting older as people wait longer to have children.<\/p>\nThis may change your marketing strategies to meet the needs and issues of this older first-time parent demographic.<\/p>\nBest for: <\/strong>Demonstrating data findings that are most noticeable and useful when the data is grouped in ranges.<\/p>\nAdvanced Excel Charts<\/h3>\nExcel also has advanced charts that are more complicated and better suited to audiences who can already read advanced-level charts. Some of these include:<\/p>\n10. <\/strong>Box and whisker chart.<\/p>\n11.<\/strong> Pareto chart.<\/p>\n12.<\/strong> Surface chart.<\/p>\n13.<\/strong> Sunburst chart.<\/p>\n14.<\/strong> Treemap chart.<\/p>\nIndustry-Specific Excel Charts<\/h3>\nThe remaining Excel chart types don\u2019t typically lend themselves to marketing. But, hey \u2014 if your niche calls for it, these charts listed below are there to support you:<\/p>\n15.<\/strong> Stock chart.<\/p>\n16.<\/strong> Waterfall chart.<\/p>\n17<\/strong>. Filled map chart.<\/p>\n18<\/strong>. Combo chart.<\/p>\nSummarizing the Charts<\/h3>\nI know this has been a ton of information. If you\u2019re still unsure which to choose, here\u2019s a concise comparison of the Excel charts I find most helpful to marketers.<\/p>\ntype of chart<\/span><\/p>\nUse<\/p>\nArea<\/strong><\/p>\nArea charts demonstrate the magnitude of a trend between two or more values over a given period.<\/p>\nClustered<\/strong>Bar<\/strong><\/p>\nClustered bar charts compare the frequency of values across different levels or variables.<\/p>\nClustered <\/strong>Column<\/strong><\/p>\nClustered column charts display data changes over a period of time to visualize rank among data sets.<\/p>\nLine<\/strong><\/p>\nSimilar to bar charts, they illustrate trends over time.<\/p>\nPie<\/strong><\/p>\nPie charts show values as percentages of a whole.<\/p>\nRadar<\/strong><\/p>\nRadar charts compare the aggregate value of multiple data series.<\/p>\nScatter<\/strong><\/p>\nScatter charts show the positive or negative relationship between two variables.<\/p>\nFunnel<\/strong><\/p>\nFunnel charts excel at visualizing changes to one data point over various processes.<\/p>\nHistogram<\/strong><\/p>\nHistograms show variations in data that are best represented as a range of values.<\/p>\nSide quest: <\/strong>If you\u2019re looking for a deeper dive to help you figure out which type of chart\/graph is best for visualizing your data, check out this free ebook, How to Use Data Visualization to Win Over Your Audience<\/a>.<\/p>\n<\/a> <\/p>\nExcel Charting Adventure: Confidence and Mastery Await<\/h2>\nLooking back on that first day when I scrambled to make my graph, I\u2019m amazed at how far I\u2019ve come in creating graphs and charts in Excel.<\/p>\nMy journey has made me realize that charting effectively is not about perfection \u2014 it’s about process. Now, with a clear, step-by-step approach, building charts has become my second nature.<\/p>\nWhether you\u2018re just starting or refining your skills, remember that every graph you create will add to your expertise. Don\u2019t be afraid to experiment, adjust, and make mistakes.<\/p>\nExcel offers endless possibilities to tell stories through data \u2014 so trust the process, have fun with it, and watch your skills grow. You\u2019ve got this!<\/p>\nEditor’s note: This post was originally published in April 2013 and has been updated for comprehensiveness.<\/em><\/p>","protected":false},"excerpt":{"rendered":"I still remember being super intimidated when asked to create a graph in Excel for […]<\/p>\n","protected":false},"author":0,"featured_media":722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":0,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/media\/722"}],"wp:attachment":[{"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/internship.infoskaters.com\/blog\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/i.ytimg.com\/vi\/Cq3ny9lPwCw\/maxresdefault.jpg\"){kind=link}