# Charts

## A collection of 15 posts

Using Pandas and XlsxWriter to create Excel charts
07 March 2022
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series. To create a pie chart of the 2017 data series,
27 October 2020
This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved. To create a thermometer chart, execute the following
27 October 2020
This example teaches you how to create a Pareto Chart in Excel. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. In this
27 October 2020
This example teaches you how to add a trendline to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next
27 October 2020
This example teaches you how to add error bars to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next
25 October 2020
Excel does not offer Gantt as chart type, but it’s easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data.
25 October 2020
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use a scatter chart (XY
25 October 2020
A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. If you are in a hurry, simply download the Excel file. This is what the
25 October 2020
A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. To create a column chart,
24 October 2020
A bar chart is the horizontal version of a column chart. Use a bar chart if you have large text labels. To create a bar chart, execute the following steps. 1. Select the
24 October 2020
A combination chart is a chart that combines two or more chart types in a single chart. To create a combination chart, execute the following steps. 1. Select the range A1:C13. 2.
24 October 2020
So far we have only seen charts on the same worksheet as the source data (embedded charts). However, you can also move a chart to a separate sheet that only contains a chart
24 October 2020
An area chart is a line chart with the areas below the lines filled with colors. Use a stacked area chart to display the contribution of each value to a total over time.
24 October 2020
Column charts are used to compare values across categories by using vertical bars. To create a column chart, execute the following steps. 1. Select the range A1:A7, hold down CTRL, and select
24 October 2020