Charts & pivot tables
Build, format and fix charts and pivot tables.
- How to Create a Rating Score Chart in Excel Step by StepTo create a rating score chart in Excel, put each item or category in one column and its numeric rating in the…
- Steps Progress Chart in Excel: Build a Clear TrackerTo create a steps progress chart in Excel, list each step and its completion percentage, calculate the remaining percentage, then plot those…
- How to Create a Timer Chart in ExcelCreate a countdown timer chart in Excel by putting the duration, elapsed time, and remaining time in worksheet cells, then charting elapsed…
- Half Circle KPI Chart in Excel: Build It Step by StepTo create a half-circle KPI chart in Excel, enter the KPI value, the amount remaining to its target, and a third slice…
- How to Create a Horizontal Bullet Chart in ExcelCreate a horizontal bullet chart in Excel by charting performance bands as a stacked bar, then placing a dark actual-value bar and…
- How to Create a Conditional Waffle Chart in ExcelCreate a conditional waffle chart in Excel by entering a percentage, filling a 10-by-10 grid with formulas that mark the first matching…
- How to Create a Funnel Chart in Excel: Step-by-StepTo create a funnel chart in Excel, place each process stage in one column and its value in the next, sort the…
- How to Create a Candlestick Chart in Excel: Step by StepTo create a candlestick chart in Excel, arrange each trading period in columns ordered Date, Open, High, Low, Close, select the full…
- Circle Bullet Chart in Excel: A Step-by-Step GuideCreate a circle bullet chart in Excel by plotting an actual value and the unused portion of a fixed scale in a…
- How to Create a Circle Progress Chart in ExcelTo create a circle progress chart in Excel, enter a completion percentage and its remaining amount in two cells, select those values,…
- Balance Chart in Excel: Track an Account Over TimeTo create a balance chart in Excel, list transaction dates and signed amounts, calculate a running balance beside them, then select the…
- Treemap Chart in Excel: How to Create OneTo create a basic treemap chart in Excel, arrange your categories in columns from broadest to most specific, put a positive numeric…
- Create a Speedometer Chart in Excel: A Step-by-Step GuideTo create a speedometer chart in Excel for Microsoft 365 on Windows, arrange your gauge bands as values in a doughnut chart,…
- Dot Progress Chart in Excel: Create One Step by StepExcel does not include a built-in chart type called a dot progress chart, but you can create the same visual with a…
- Gauge Chart in Excel: Build and Format OneTo make a gauge chart in Excel for Microsoft 365 on Windows, create a doughnut chart from three values: the current value,…
- How to Create a Custom Column Chart in ExcelTo create a custom column chart in Excel for Microsoft 365 on Windows, arrange category labels and numeric values in adjacent columns,…
- Create a Full-Circle KPI Chart in Excel: Step-by-StepTo create a full-circle KPI chart in Excel, enter a progress value and its remainder as two numbers, select them, then choose…
- Conditional Progress Circle Chart in Excel: Build OneYes. In Excel for Microsoft 365 on Windows, you can make a conditional progress circle with a doughnut chart and helper formulas:…
- Create a Balloon Chart in Excel: A Practical GuideTo create a balloon chart in Excel, arrange your data in columns for X values, Y values, and bubble size, select those…
- Battery Chart in Excel: Build a Clear Charge GaugeYes—Excel can show a battery’s charge as a simple gauge using a 100% stacked bar chart. Enter the charge as a percentage,…
- Bullseye Chart in Excel: How to Make OneExcel has no built-in chart type called a bullseye chart, but you can make one with concentric circles and a marker, or…
- 3D Pie Chart in Excel: How to Create and Format ItTo create a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column list of category names and values,…
- Spider Web Chart in Excel: Make a Radar Chart Look GreatTo make a spider web chart look great in Excel, arrange comparable measures in a table, select the data, and choose Insert…
- Spider Web Chart in Excel: Create and Format a Radar ChartTo make a spider web chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each…
- Line Balancing Chart in Excel: Build One Step by StepA line balancing chart in Excel compares the work assigned to each station with a target cycle time, often takt time, so…
- Balloon Chart in Excel: A Step-by-Step TutorialTo make a balloon chart in Excel for Microsoft 365 on Windows, arrange your data in columns for X values, Y values,…
- How to Create a 3-D Pie Chart in Excel Step by StepTo create a 3-D pie chart in Excel for Microsoft 365 on Windows, select a category column and its matching values, then…
- Excel Half Circle Chart: How to Create OneTo make a half-circle chart in Excel, create a doughnut chart with two visible values and a third value equal to their…
- Rating Chart in Excel: Build Stars and Score ChartsTo make a five-star rating chart in Excel, enter whole-number ratings from 1 to 5 in column B, then put this formula…
- Butterfly Chart in Excel: How to Build and Format OneTo make a butterfly chart in Excel, put the values for one group in a column as negative numbers and the other…