---
description: Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to
title: Advanced Excel Charts & Graphs [With Template]
image: https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png
---

 

[Skip to content](#main) 

**⚡ Smart Summary**

Advanced Charts in Excel go beyond the basic chart by combining more than one data set on a single graph. This page explains what an advanced chart is, builds a combo chart of articles published against site traffic, and adds a secondary axis with axis titles.

* 📊 **Core Definition:** An advanced chart goes beyond the basic chart by comparing several data sets on one graph with extra formatting.
* 🔗 **Consolidation:** It puts two related series, such as articles published and site visitors, side by side to show their relationship.
* 🧩 **Combo Chart:** Change the chart type to Combo, then set one series as a clustered column and the other as a line.
* 📏 **Secondary Axis:** When two series use different scales, a secondary axis keeps both readable on the same chart.
* 🏷️ **Titles:** Add chart and axis titles from Add Chart Elements so the reader understands each scale.
* 🎨 **Purpose:** The finished chart shows the effect of one data set on the other at a glance.

[ Read More ](javascript:void%280%29;) 

![Advanced Charts and Graphs in Excel](https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png)

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This tutorial will focus on that complexity.

## What is an advanced chart?

An advanced chart is a chart that goes beyond the basic charts created by Excel. Let’s say you have more than one set of data that you would like to compare on the same chart, you can create your basic chart with one set of data then add more datasets to it and apply other items i.e. formatting to the chart. This is what advanced charts are all about.

## The importance of advanced charts

* They provide consolidated information in a single chart that makes it easier to compare more than one data set and make decisions quickly for complex charts in [Excel](https://www.guru99.com/excel-tutorials.html)
* They allow us to customize the look and feel of the professional Excel charts

## Common Advanced Chart Types in Excel

The combo chart built below is the most common advanced chart, but Excel offers several others for specific jobs. The table shows when to reach for each one.

| Chart type           | Best used for                                                               |
| -------------------- | --------------------------------------------------------------------------- |
| Combo chart          | Two series of different kinds, such as a column and a line, on one chart    |
| Secondary axis chart | Two series with very different scales, such as a count and a percentage     |
| Waterfall            | How a starting value rises and falls to a final total, such as cash flow    |
| Pareto               | The few categories that account for most of the total, using the 80/20 rule |
| Histogram            | The frequency of values grouped into ranges, such as ages or scores         |
| Sparkline            | A tiny trend line inside a single cell, next to the data                    |

**💡 Tip:** Most of these appear under Insert then Recommended Charts or the Charts group. The [sparkline](https://www.guru99.com/excel-sparkline-example.html) is the exception, and is added from the Insert, Sparklines group instead.

## Step by step example of creating advanced charts

In this [Excel Charts](https://www.guru99.com/visualizing-data-using-charts-in-excel.html) tutorial exercise, we will assume that we run a blog and have software that gives us the number of monthly visitors. We would like to see the relationship between the numbers of articles published per month vs the total month traffic. We will work with the following data set.

| Month | Articles Published | Site Visitors |
| ----- | ------------------ | ------------- |
| Jan   | 20                 | 120           |
| Feb   | 16                 | 145           |
| Mar   | 19                 | 130           |
| Apr   | 25                 | 200           |
| Jun   | 20                 | 230           |
| Jul   | 13                 | 221           |

### RELATED ARTICLES

* [MS Excel Notes 101 for Beginners ](https://www.guru99.com/introduction-to-microsoft-excel.html "MS Excel Notes 101 for Beginners")
* [Microsoft Office 365 Cloud: Benefits of Microsoft Excel Cloud ](https://www.guru99.com/excel-in-the-cloud-office-365.html "Microsoft Office 365 Cloud: Benefits of Microsoft Excel Cloud")
* [Sparklines in Excel: What is, Types, Location Range (Examples) ](https://www.guru99.com/excel-sparkline-example.html "Sparklines in Excel: What is, Types, Location Range (Examples)")
* [15 BEST Excel Books (2026 Update) ](https://www.guru99.com/best-excel-books.html "15 BEST Excel Books (2026 Update)")

**Step 1)** Create a new workbook in Excel

* Enter the data shown above
* Create a basic column chart as shown below. If you do not know how to create a basic chart, then read the article on charts.

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv1.png)

**Step 2)** Now, it’s time for our charts and complex graphs in Excel to take beyond the basics. Select the orange bars representing traffic

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv2.png)

**Step 3)** Click on change chart type as shown below

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv3.png)

* You will get the following dialog window

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv4.png)

**Step 4)** Select Combo and,

1. Click on the clustered column
2. Select Line chart
3. Click on OK button

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv5.png)

Congratulations, you just created a creative Excel chart with two types of charts in it.

Let’s now add a secondary axis to our chart to make it look more presentable.

* Select the chart
* Click on Design under chart tools and select change chart type

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv6.png)

1. Click on Secondary Axis check box under Site Visitors
2. Click on OK button

Let’s now edit the chart, primary and secondary axis titles as shown below.

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv7.png)

1. Go to Add chart elements
2. Click on Axis titles
3. Select primary verticals
4. Double click on the chart title and edit the title

Write Monthly Published Articles vs Site Traffic. Your complete chart should now look as follows

[](https://www.guru99.com/images/5-2015/050215%5F1209%5FCreatingAdv8.png)

As you can see from the above complete chart, we have consolidated two data sets and visualized them in such a way that it easily shows the effect of one data set onto the other using Excel graphs.

[Advanced Excel Charts and Graphs Template](https://docs.google.com/spreadsheets/d/1uutHZqLfx49kPizRjNSBoKsYa3iOXSDV/export?format=xlsx)

## FAQs

⚡ What is a combo chart in Excel?

A combo chart shows two or more series as different chart types on one plot, for example one series as columns and another as a line. It is used to compare related data that would not read well in a single type.

📏 When should I add a secondary axis?

Add a secondary axis when two series use very different scales, such as 20 articles against 200 visitors. Without it, the smaller series is flattened at the bottom of the chart and cannot be read.

🏷️ How do I add axis titles to a chart?

Select the chart, click the Chart Elements plus sign, and tick Axis Titles. Then click each title and type the label, so the reader knows what the primary and secondary axes measure.

🤖 Can AI build an advanced combo chart for me?

Yes. AI features such as Copilot in Excel create a combo chart, set the secondary axis, and add titles from a plain request like “compare articles and visitors”. The user then fine tunes the colours and labels.

🧠 Can AI find the relationship shown in an advanced chart?

Yes. AI assistants read the two series and describe the relationship, such as whether more articles lead to more visitors. The user confirms the correlation against the chart before drawing a conclusion.

#### Summarize this post with:

ChatGPT Perplexity Grok Google AI 

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** 

##### Sign up for the newsletter

Subscribe for Free 

You have successfully subscribed.  
Please check your inbox. 

![AI-Newsletter]() Chosen by over **350,000+** professionals 

[Scroll to top ](#wrapper)Scroll to top 

× 

Toggle Menu Close 

Search for: 

Search

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png","url":"https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png","width":"700","height":"250","caption":"Advanced Charts & Graphs in Excel","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/excel","name":"Excel"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html","name":"Advanced Excel Charts & Graphs [With Template]"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#webpage","url":"https://www.guru99.com/creating-advanced-charts-in-excel.html","name":"Advanced Excel Charts & Graphs [With Template]","dateModified":"2026-07-15T13:31:49+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller","description":"I am Charlotte Miller, an Excel VBA Developer with over a decade of first-hand experience.","url":"https://www.guru99.com/author/charlotte","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/charlotte-miller-author.png","url":"https://www.guru99.com/images/charlotte-miller-author.png","caption":"Charlotte Miller","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"Excel","headline":"Advanced Excel Charts & Graphs [With Template]","description":"Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to","keywords":"excel","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller"},"dateModified":"2026-07-15T13:31:49+05:30","image":{"@id":"https://www.guru99.com/images/advanced-charts-and-graphs-in-excel.png"},"copyrightYear":"2026","name":"Advanced Excel Charts & Graphs [With Template]","subjectOf":[{"@type":"HowTo","name":"Step by step example of How to creating advanced charts","description":"Here is step by step process to create advance charts","step":[{"@type":"HowToStep","name":"Step 1) Create a new workbook in Excel","text":"Enter the data shown above and Create a basic column chart as shown below.","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/5-2015/050215_1209_CreatingAdv1.png"},"url":"https://www.guru99.com/creating-advanced-charts-in-excel.html#step1"},{"@type":"HowToStep","name":"Step 2) Now, it's time for our charts and complex graphs in Excel to take beyond the basics.","text":"Select the orange bars representing traffic","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/5-2015/050215_1209_CreatingAdv2.png"},"url":"https://www.guru99.com/creating-advanced-charts-in-excel.html#step2"},{"@type":"HowToStep","name":"Step 3) Click on change chart type as shown below","text":"You will get the following dialog window","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/5-2015/050215_1209_CreatingAdv3.png"},"url":"https://www.guru99.com/creating-advanced-charts-in-excel.html#step3"},{"@type":"HowToStep","name":"Step 4) Select Combo","text":"Click on the clustered column, Select Line chart and Click on OK button","image":{"@type":"ImageObject","url":"https://cdn.guru99.com/images/5-2015/050215_1209_CreatingAdv5.png"},"url":"https://www.guru99.com/creating-advanced-charts-in-excel.html#step4"}]},{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is a combo chart in Excel?","acceptedAnswer":{"@type":"Answer","text":"A combo chart shows two or more series as different chart types on one plot, for example one series as columns and another as a line. It is used to compare related data that would not read well in a single type."}},{"@type":"Question","name":"When should I add a secondary axis?","acceptedAnswer":{"@type":"Answer","text":"Add a secondary axis when two series use very different scales, such as 20 articles against 200 visitors. Without it, the smaller series is flattened at the bottom of the chart and cannot be read."}},{"@type":"Question","name":"How do I add axis titles to a chart?","acceptedAnswer":{"@type":"Answer","text":"Select the chart, click the Chart Elements plus sign, and tick Axis Titles. Then click each title and type the label, so the reader knows what the primary and secondary axes measure."}},{"@type":"Question","name":"Can AI build an advanced combo chart for me?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI features such as Copilot in Excel create a combo chart, set the secondary axis, and add titles from a plain request like compare articles and visitors. The user then fine tunes the colours and labels."}},{"@type":"Question","name":"Can AI find the relationship shown in an advanced chart?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI assistants read the two series and describe the relationship, such as whether more articles lead to more visitors. The user confirms the correlation against the chart before drawing a conclusion."}}]}],"@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#schema-30922","isPartOf":{"@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/creating-advanced-charts-in-excel.html#webpage"}}]}
```