Contextures

Index to Excel Chart Articles

Links to some of the popular Excel chart tutorials on the Contextures site and blogs. Build a box plot chart, pie chart, Gantt chart, a line chart, or a fancy clustered stacked chart!

Author: Debra Dalgleish

How to Build an Excel Box Plot Chart

With a Box Plot (box and whisker chart), you can see the distribution of numbers in data. Excel 2013, and earlier versions, don't have a Box Plot chart type, but you can create your own version, by adding calculations to the worksheet, and using a Stacked Column chart type, with error bars.

Go to the Box Plot tutorial, for step-by-step videos and written steps. and a sample file to download.

Paste Special

Excel Line Column Chart 2 Axes

If you use two different chart types in a single chart, it's called a combination chart, like the line-column chart shown below. This example is on 2 axes, and shows the sales dollars, in columns, and number of cases sold, in a line, for each product.

Go to the Line Column Chart tutorial, for step-by-step videos and written steps. and a sample file to download.

combination chart

How to Make an Excel Pie Chart

A pie chart is a circle, with one or more slices, and each slice is sized to show its share of the overall total amount. See how to build a simple pie chart, and you can even add pictures to the pie chart slices, for a bit of fun, like the red or white pizza survey, shown below.

Go to the Pie Chart tutorial, for step-by-step videos and written steps. and a sample file to download.

pizzapiechart05

Create Excel Cluster Stack Chart

A cluster stack chart has clusters of columns or bars, with a stack in each column or bar. See how to set up your Excel data to create a cluster stack column chart or a cluster stack bar chart. Or use a pivot table and pivot chart, for a quick and easy solution.

Go to the Cluster Stack Chart tutorial, for step-by-step videos and written steps. and a sample file to download.

cluster stack column chart

Gantt Chart Project Plan

Although Excel doesn't have a built in Gantt chart type, you create a simple project plan in Excel, with a Gantt chart timeline. There are sophisticated project management tools, like Microsoft Project, but for small projects, where you don't need to manage a complex set of tasks and resources, Excel can probably do what you need.

Go to the Gantt Chart tutorial, for step-by-step videos and written steps. and a sample file to download.

completed Gantt chart

Video: Line Chart With Target Range

In this video, see how to build an Excel line chart to show sales over six months, and show the target sales range in the chart's background. In the data, add the high and low values for the target range, and show that range in the background of the line chart.

For written steps, go to the Create an Excel Line Chart with Target Range page

More Excel Chart Tutorials

Here are links to a few more Excel chart tutorials from Contextures:

Seating Plan, Chart shows Guest Tables

Chart Error Bars VBA

Show Hidden Data in Charts

Interactive Chart - Totals

Marimekko Charts

Panel Charts

Pivot Chart - Compare Years

Waterfall Charts

 

 

About Debra

 

Last updated: August 14, 2022 1:51 PM