Insert a Pivot Table | Drag fields | Sort | Filter | Change Summary Calculation | Two-dimensional Pivot Table Pivot tables are one of Excel’s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 213 records and 6 fields. Order ID, […]
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 example, we will see that roughly 80% of the complaints come from 20% of the complaint types. To create a Pareto chart […]
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. To create a Gantt chart, execute the following steps. 1. Select the range A3:C11. 2. On the Insert tab, in the Charts group, click […]
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 steps. 1. Select cell B16. Note: adjacent cells should be empty. 2. On the Insert tab, in the Charts group, click the […]
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 spreadsheet looks like. To create a gauge chart, execute the following steps. 1. Select the range H2:I6. Note: the Donut series has […]
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. On the Insert tab, in the Charts group, click the Combo symbol. 3. Click Create Custom Combo Chart. The Insert Chart dialog box […]
Insert Sparklines | Customize Sparklines Sparklines in Excel are graphs that fit in one cell and give you information about the data. Insert Sparklines To insert sparklines, execute the following steps. 1. Select the cells where you want the sparklines to appear. In this example, we select the range G2:G4. 2. On the Insert tab, […]
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 to Error Bars and then click More Options. Notice the shortcuts to quickly display error bars using the Standard Error, a […]
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 to Trendline and then click More Options. The Format Trendline pane appears. 3. Choose a Trend/Regression type. Click Linear. 4. Specify […]
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 (chart sheet). To move a chart to a chart sheet, execute the following steps. 1. Select the chart. 2. On the Design […]
Axis Type | Axis Titles | Axis Scale Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This example teaches you how to change the axis type, add axis titles and how to change the scale of the vertical axis. To create a column chart, execute the […]
Select Data Source | Switch Row/Column | Add, Edit, Remove and Move 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, execute the following steps. 1. Select the range A1:D7. 2. […]
Straight Lines | Only Markers Use a scatter chart (XY chart) to show scientific XY data. Scatter charts are often used to find out if there’s a relationship between variable X and Y. Straight Lines To create a scatter chart, execute the following steps. 1. Select the range A1:D22. 2. On the Insert tab, in […]
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. To create an area chart, execute the following steps. 1. Select the range A1:D7. 2. On the Insert tab, in the Charts […]
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 range A1:B6. 2. On the Insert tab, in the Charts group, click the Column symbol. 3. Click Clustered Bar. Result: .
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, execute the following steps. 1. Select the range A1:D2. 2. On the Insert tab, in the Charts group, click the Pie symbol. […]
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 chart) to show scientific XY data. To create a line chart, execute the following steps. 1. Select the range A1:D7. 2. On […]
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 the range C1:D7. 2. On the Insert tab, in the Charts group, click the Column symbol. 3. Click Clustered Column. Result: Note: only […]
A simple chart in Excel can say more than a sheet full of numbers. As you’ll see, creating charts is very easy. Creating chart in MS Excel Combination Chart Error Bars Chart Sheet Data Series Gantt Chart Gauge Chart Sparklines Trendline Axes Pareto Chart Thermometer Chart Scatter Chart Area Chart Bar Chart Pie Chart Line […]
This example teaches you how to create a checklist in Excel. First, turn on the Developer tab. Next, you can create a checklist. To create this checklist, execute the following steps. 1. On the Developer tab, in the Controls group, click Insert. 2. Click Check Box in the Form Controls section. 3. Draw a check […]
