Top 5 Advanced Excel Charts and How to Create them

No doubt Excel is great for handling data and performing any analysis on it but you’ll agree when we say Excel spreadsheet has limitations that can break your data story.

For starters, Excel comes with a limited library of charts you can use to visualize your data.

Well, the solution is not to ditch your beloved Excel. There’s a tool that comes with advanced Excel charts to supercharge your favorite spreadsheet. And it gets better.

This tool comes with over 80 advanced Excel charts and graphs. Read the blog in its entirety to discover the tool you need to create stunning and insightful charts.

In this blog post, we’ve rounded up strategies and a visualization tool you can use to get the most out of your data with Excel. Keep reading if your goal is to take your data storytelling skills to the next level.

In this blog, you’ll discover:

• How to Visualize your Data with Advanced Excel Charts
• How to Install ChartExpo Add-in to Access Advanced Excel Charts and Graphs
• Top 5 Advanced Excel Charts and Graphs You Can Only Access in ChartExpo.

How to Visualize your Data with Advanced Excel Charts

You’ll agree when we say that poring over spreadsheets of data is time-consuming. You don’t want to undertake a task that software performs efficiently.

If you want to extract in-depth, actionable insights from your data, you’ve got to use charts. And this is where spreadsheet tools, such as Excel, come in.

The spreadsheet app mentioned above comes pre-loaded with advanced Excel charts. And you can use these charts to create data stories that make sense to your audience.

Some of the advanced Excel charts and graphs are amazingly easy to read and understand.

So how can you visualize data using advanced Excel charts?

• To get started with Excel, select the data you want to visualize.
• Click the Quick Analysis Tool button (at the bottom right of the selected data) and select the Charts option, as shown.

From the diagram above, although there is option for more charts, but it is obvious that Excel has a smaller library of charts because many of the charts of similar type. And this means Excel is not all-encompassing for visualizing data.

You need a tool that’s loaded with more charts.

Why?

To know the best chart that complements your data story, you’ve got to test with diverse audiences. More so, you’ve got to have enough charts to select the right one depending on your goals and the nature of the data.

So what’s the solution?

The tool we always recommend to our clients is ChartExpo.

Well, this highly pocket-friendly and easy-to-use tool comes as an add-in for Excel.

Besides, it comes with a super user-friendly interface to provide you unlimited access and convenience. So, you don’t need programming or coding skills to use it.

ChartExpo has multiple advanced Excel charts and graphs, plus more. Yes, you read that right.

How to Install ChartExpo Add-in to Access Advanced Excel Charts and Graphs?

To get started with ChartExpo for Excel add-In, follow the simple and easy steps below.

• Open your Excel application (Excel 2013 with sp1) or later).
• Open the worksheet and click on the Insert menu.
• Click My Apps and then click on See All, as shown.

• Search for a ChartExpo add-in in my Apps Store.
• Click on the Insert

• The add-in will be added to the Excel application, as shown.
• Log in with your Microsoft account or create a new account by clicking the Create New
• Enter your newly created account and start using the ChartExpo add-in. You’re only required to log in for the first time. Next time, ChartExpo won’t ask for your details.

• Open your ChartExpo to access 6 different categories of charts, as shown.

Let’s take a look at the examples below. You’ll get to see how you can access advanced Excel charts and graphs in Excel.

You don’t want to miss the next section.

Top 5 Advanced Excel Charts and Graphs You Can Only Access in ChartExpo.

1. Pareto Chart

• To access Pareto Charts, click Pay-per-click (PPC) Charts category, as shown.

Notice (in the screenshot above) 2 variants of Pareto Charts you can use to visualize your data for insights. We’ll use the Pareto Bar Chart for our example below.

Let’s use the table below.

City	Current Profit	Previous Profit
New York	540	510
Chicago	550	545
San Francisco	115	99
Los Angeles	572	533
Seattle	93	85
Boston	88	63
Phoenix	497	485
Atlanta	115	80
Philadelphia	489	470
Miami	87	67
Dallas	107	115
Houston	570	580
St Louis	97	90

• Click Explore Sample Data button to get started with the Pareto advanced Excel chart. The add-in will auto-generate data into your sheet you can use for practice.

• Click Create Chart from the Sheet Data button to visualize the selected data using Pareto Diagrams, as shown.
• Check out our insightful Pareto Chart below.

So what are the insights?

• Los Angeles, Houston, Chicago, New York, and Phoenix account for 80% of the overall performance.
• Cities that account for 80% of the profit are above the horizontal grey line. Conversely, cities that account for 20% of the total profit are below the line.

Remember, Pareto is one of the advanced Excel charts and graphs you can use to extract in-depth, actionable insights.

2. CSAT-Score-Survey-Chart (NPS Chart)

Imagine you own a restaurant and you want to establish whether the existing customers can recommend your brand to others. You’ve already collected data.

The only part remaining is selecting the right chart.

Where would you start?

This is where ChartExpo comes in. This tool comes loaded with charts tailored-made specifically for surveys. We’ll use CSAT Score Survey Chart (NPS Chart – Located in the Specialized Survey Charts category).

Let’s use the table below for our scenario.

Question	Rating	Count
Would you recommend our restaurant?	0	10
Would you recommend our restaurant?	1	45
Would you recommend our restaurant?	2	61
Would you recommend our restaurant?	3	80
Would you recommend our restaurant?	4	123
Would you recommend our restaurant?	5	75
Would you recommend our restaurant?	6	41
Would you recommend our restaurant?	7	88
Would you recommend our restaurant?	8	45
Would you recommend our restaurant?	9	544
Would you recommend our restaurant?	10	209

• Remember to follow the steps we highlighted earlier to visualize your data in Excel using ChartExpo.
• After following all the steps, your chart should look like the one below.

So how do you interpret an CSAT-Score-Survey-Chart Chart?

The restaurant brand’s Score is 24. This chart categorizes respondents into the following groups.

• Promoters (score 9-10) are loyal enthusiasts who will keep buying and referring others to the brand.
• Neutral (score 7-8) are satisfied but unenthusiastic customers who are vulnerable to competitive offerings.
• Detractors (score 0-6) are unhappy customers who can damage your brand and impede growth through negative publicity.

Subtracting the percentage of Detractors from Promoters yields the Net Promoter Score (which is 24 in our scenario).  More so, the score ranges from -100 (if every customer is a Detractor) to +100 (if every customer is a Promoter).

NPS score is solved using the formula below.

NPS Score = % of Promoters — % of Detractors

Remember, NPS Score Chart is one of the advanced Excel charts you can use to extract in-depth insights from your survey data.

3. Comparison Sentiment Chart

Let’s build on the earlier example.

Imagine you’ve gathered customer feedback from all the key departments of your restaurant brand. You want to compare the performance across 3 years to optimize for maximum customer satisfaction and revenue.

We’ll use a Comparison Sentiment Chart because we have multiple survey data points to visualize.

Let’s use the table below for our scenario.

Year	Service	Sentiment	Count
2018	Ease of Ordering	Positive	11
2018	Ease of Ordering	Negative	12
2018	Cleanness	Positive	29
2018	Cleanness	Negative	50
2018	Services	Positive	20
2018	Services	Negative	33
2018	Payment Method	Positive	2
2018	Payment Method	Negative	4
2018	Wait Time To Be Seated	Positive	55
2018	Wait Time To Be Seated	Negative	12
2018	Quality of Food	Positive	12
2018	Quality of Food	Negative	7
2018	Menu Readability	Positive	16
2018	Menu Readability	Negative	11
2018	Seating Space Area	Positive	8
2018	Seating Space Area	Negative	8
2018	Call	Positive	4
2018	Call	Negative	3
2018	Attitude of Waiter	Positive	3
2018	Attitude of Waiter	Negative	5
2018	Cost	Positive	12
2018	Cost	Negative	15
2019	Ease of Ordering	Positive	15
2019	Ease of Ordering	Negative	12
2019	Cleanness	Positive	51
2019	Cleanness	Negative	1
2019	Services	Positive	28
2019	Services	Negative	12
2019	Payment Method	Positive	4
2019	Payment Method	Negative	2
2019	Wait Time To Be Seated	Positive	45
2019	Wait Time To Be Seated	Negative	11
2019	Quality of Food	Positive	12
2019	Quality of Food	Negative	8
2019	Menu Readability	Positive	16
2019	Menu Readability	Negative	18
2019	Seating Space Area	Positive	13
2019	Seating Space Area	Negative	18
2019	Call	Positive	4
2019	Call	Negative	1
2019	Attitude of Waiter	Positive	3
2019	Attitude of Waiter	Negative	8
2019	Cost	Positive	17
2019	Cost	Negative	16
2020	Ease of Ordering	Positive	18
2020	Ease of Ordering	Negative	12
2020	Cleanness	Positive	59
2020	Cleanness	Negative	20
2020	Services	Positive	30
2020	Services	Negative	10
2020	Payment Method	Positive	2
2020	Payment Method	Negative	0
2020	Wait Time To Be Seated	Positive	55
2020	Wait Time To Be Seated	Negative	7
2020	Quality of Food	Positive	18
2020	Quality of Food	Negative	10
2020	Menu Readability	Positive	22
2020	Menu Readability	Negative	14
2020	Seating Space Area	Positive	13
2020	Seating Space Area	Negative	16
2020	Call	Positive	4
2020	Call	Negative	1
2020	Attitude of Waiter	Positive	2
2020	Attitude of Waiter	Negative	4
2020	Cost	Positive	13
2020	Cost	Negative	14

• Remember to follow the steps we highlighted earlier. Your chart should look like the one below.

A Comparison Sentiment Diagram is one of the advanced Excel charts and graphs you can use to extract actionable insights.

4. Sentiment Trend Chart

Imagine you run a beauty brand. You want to identify customers’ sentiments towards your products.

Where would you start?

Yes, you got it right. Start by comparing the count of negative and positive ratings of the products in the inventory.

Let’s use the table below for our scenario.

Month	Positive Count	Negative Count	Difference
Mar	4571	1524	3047
Apr	4259	1645	2614
May	4755	1976	2779
Jun	4566	2273	2293
Jul	4317	1598	2719
Aug	3763	1421	2342

• Follow the steps we highlighted earlier to visualize your data in Excel using ChartExpo.
• Your chart should look like the one below.

So what are the insights?

• June has the lowest positive sentiment. On the other hand, March has the highest positive sentiment.
• A Sentiment Comparison Diagram is one of the advanced Excel charts and graphs you can use to extract in-depth, actionable insights from your survey data.

5. Matrix Chart

Imagine you run a Google Ads campaign. You want to optimize your account by pausing unproductive keywords with respect to the following metrics:

• Impressions
• Clicks
• Conversion
• Costs (Cost per action)

Which chart would you use to visualize your campaign data for actionable insights?

This is where a Matrix Chart comes in.

Let’s use the tabular data below for our scenario.

Category	Sub Category	Period	Measure
Mobile	Impressions	Current	2470
Mobile	Clicks	Current	109
Mobile	Conversions	Current	3
Mobile	Cost	Current	2030.9
Smartphone	Impressions	Current	2459
Smartphone	Clicks	Current	35
Smartphone	Conversions	Current	1
Smartphone	Cost	Current	803.1
Phone	Impressions	Current	2256
Phone	Clicks	Current	112
Phone	Conversions	Current	4
Phone	Cost	Current	2160
Mobile Phones	Impressions	Current	1802
Mobile Phones	Clicks	Current	87
Mobile Phones	Conversions	Current	1
Mobile Phones	Cost	Current	1469.9
Cellphones	Impressions	Current	750
Cellphones	Clicks	Current	56
Cellphones	Conversions	Current	0
Cellphones	Cost	Current	531.1
Mobile shop	Impressions	Current	637
Mobile shop	Clicks	Current	58
Mobile shop	Conversions	Current	0
Mobile shop	Cost	Current	1559.6
Free phones	Impressions	Current	627
Free phones	Clicks	Current	38
Free phones	Conversions	Current	0
Free phones	Cost	Current	377.6
Prepaid Phones	Impressions	Current	626
Prepaid Phones	Clicks	Current	21
Prepaid Phones	Conversions	Current	2
Prepaid Phones	Cost	Current	488.4
Cheap Phones	Impressions	Current	619
Cheap Phones	Clicks	Current	47
Cheap Phones	Conversions	Current	0
Cheap Phones	Cost	Current	4024.3
New Phones	Impressions	Current	587
New Phones	Clicks	Current	21
New Phones	Conversions	Current	0
New Phones	Cost	Current	477
Latest Mobile Phones	Impressions	Current	474
Latest Mobile Phones	Clicks	Current	31
Latest Mobile Phones	Conversions	Current	2
Latest Mobile Phones	Cost	Current	586.6
Best Phone	Impressions	Current	445
Best Phone	Clicks	Current	23
Best Phone	Conversions	Current	0
Best Phone	Cost	Current	487.3
Mobile Price	Impressions	Current	440
Mobile Price	Clicks	Current	28
Mobile Price	Conversions	Current	4
Mobile Price	Cost	Current	565.4

• Remember to follow the steps we highlighted earlier to visualize your data in Excel using ChartExpo.
• Your chart should be similar to the one shown below.

So what are the insights?

• The best performing keywords with respect to conversion are “mobile,” “phone,” and “mobile price.”
• The less profitable keyword in the campaign is “cheap phones” because it has zero conversion and high costs (cost per click).

FAQs:

How can you create a complicated chart?

To visualize your data with advanced Excel charts, you have to supercharge your spreadsheet with a third-party add-in.

The add-in that seasoned data visualization experts use is ChartExpo.

This tool has advanced charts to ensure you’ve got enough diagrams to choose from for your data story.

Which type of Excel chart is the most popular for showing trends?

Line Charts are among the most popular visualizations seasoned experts use to display patterns and trends in data. These charts are amazingly easy to read and interpret, even for non-technical audiences.

You can easily access Line Chart and Scatter Plot templates in your Excel.

Wrap Up

As we said earlier, visualizing data in Excel comes with limitations that can break your data story.

Why?

The spreadsheet tool mentioned above comes with a shallow library of charts. And this means there’re advanced Excel charts and graphs you can only access via a third-party add-in.

The third-party add-in we recommend you to use to create easy to read charts is ChartExpo. And this is because:

• You don’t need coding or scripting skills.
• ChartExpo produces visualizations that are easy to read and interpret.
• You can export your charts easily in JPEG and PNG formats.

Use ChartExpo as your data visualization partner to create data narratives that attract instant buy-in.