Main Topics
- Cornerstone Articles (Important and Popular Posts)
- Animated Charts
- Axis Labels
- Axis Scales
- Axis – Multi Tier Category Labels
- Chart Events
- Combination Charts
- Conditional Formatting of Charts
- Custom Chart Types
- Data Labels
- Dynamic Arrays, LET, and LAMBDA
- Dynamic Charts
- Dynamic Array Charts
- Error Bars
- Floating Bars
- Gantt Charts
- Gaps
- Histograms
- Interactive Charts
- Legends
- Marimekko Charts
- Mathematics
- Moving Averages
- Panel Charts
- Pivot Tables and Charts
- SERIES Formula
- Slope Charts
- Statistical Process Control
- Statistics
- Tables
- Trendlines and Regression
Cornerstone Articles (Important and Popular Posts)
- Good Chart Data
- The Excel Chart SERIES Formula
- Install an Excel Add-In
- Excel Waterfall Charts (Bridge Charts)
- Clustered and Stacked Column and Bar Charts
- Excel Box and Whisker Diagrams (Box Plots)
- Gantt Charts in Microsoft Excel
- Step Charts in Excel
- Add a Horizontal Line to an Excel Chart
- Fill Under or Between Series in an Excel XY Chart
- Conditional Formatting of Excel Charts
- Referencing Pivot Table Ranges in VBA
- Excel Interpolation Formulas
- Unlink Chart Data
Animated Charts
Axis Labels
- LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels
- Text Labels on a Horizontal Bar Chart in Excel
- Reciprocal Chart Axis Scale
- Custom Axis Labels and Gridlines in an Excel Chart
- Chart with a Dual Category Axis
- Using Pivot Table Data for a Chart with a Dual Category Axis
- Stagger Axis Labels to Prevent Overlapping
- Axis Labels on Small Charts
- Column Chart with Category Axis Labels Between Columns
- Axis Labels That Don’t Block Plotted Data
- Individually Formatted Category Axis Labels
- Excel Plotted My Bar Chart Upside-Down
- Why Are My Excel Bar Chart Categories Backwards?
Axis Scales
- LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels
- Excel Chart with Square Gridlines
- Calculate Nice Axis Scales with LET and LAMBDA
- Calculate Nice Axis Scales in Your Excel Worksheet
- Calculate Nice Axis Scales in Excel VBA
- Chart UDF to Control Axis Scale
- How Excel Calculates Automatic Chart Axis Limits
- Reciprocal Chart Axis Scale
- Custom Axis Labels and Gridlines in an Excel Chart
- Custom Axis, Y = 1, 2, 4, 8, 16
- Logarithmic Axis Scales
- Link Excel Chart Axis Scale to Values in Cells
- Consistent Axis Scales Across Multiple Charts
- Gantt Chart with Nice Date Axis
- Select Meaningful Axis Scales
- Bar Chart Value Axis Scale Must Include Zero
- Text Labels on a Horizontal Bar Chart in Excel
Axis – Multi Tier Category Labels
- Dynamic Arrays, Names, and Multi-Tier Categories
- LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels
- Chart with a Dual Category Axis
- Using Pivot Table Data for a Chart with a Dual Category Axis
Chart Events
- Chart Events in Microsoft Excel
- Chart Event to Highlight a Series
- Chart Event Class Module to Highlight a Series
- Highlight a Series with a Click or a Mouse Over
Combination Charts
- Pareto Charts in Excel
- Clustered Column and Line Combination Chart
- Precision Positioning of XY Data Points
- Add a Horizontal Line to an Excel Chart
- Horizontal Line Behind Columns in an Excel Chart
- Bar-Line (XY) Combination Chart in Excel
- Salary Chart: Plot Markers on Floating Bars
- Shaded Quadrant Background for Excel XY Scatter Chart
- Excel Chart With Colored Quadrant Background
- Fill Under or Between Series in an Excel XY Chart
- Fill Under a Plotted Line: The Standard Normal Curve
Conditional Formatting of Charts
- Conditional Formatting of Excel Charts
- Conditional XY Charts Without VBA
- Invert if Negative Formatting in Excel Charts
- Conditional Donut Chart
- Highlight Min and Max Data Points in an Excel Chart
- Split Data Range into Multiple Chart Series without VBA
- Conditional Formatting of Lines in an Excel Line Chart Using VBA
- VBA Conditional Formatting of Charts by Value and Label
- VBA Conditional Formatting of Charts by Series Name
- VBA Conditional Formatting of Charts by Value
- VBA Conditional Formatting of Charts by Category Label
Custom Chart Types
- Excel Waterfall Charts (Bridge Charts)
- Excel Box and Whisker Diagrams (Box Plots)
- Clustered and Stacked Column and Bar Charts
- Step Charts in Excel
- Cycle Plots in Excel
- Diverging Stacked Bar Charts
- Dot Plots
- Slope Charts
- Pareto Charts in Excel
- See Marimekko Charts
- See Gantt Charts
- See Slope Charts
Data Labels
- Slope Chart with Data Labels
- Prevent Overlapping Data Labels in Excel Charts
- Apply Custom Data Labels to Charted Points
- Label Each Series in a Chart
- Label Last Point for Excel 2007
- Add Totals to Stacked Bar Chart
- Custom Axis Labels and Gridlines in an Excel Chart
- Text Labels on a Horizontal Bar Chart in Excel
Dynamic Arrays, LET, and LAMBDA
- ISPRIME Lambda Function
- Lambda Moving Average Formulas
- Improved Excel Lambda Moving Average
- Excel Lambda Moving Average
- LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels
- Dynamic Array Histogram
- Calculate Nice Axis Scales with LET and LAMBDA
- VBA Test for New Excel Functions
- Dynamic Arrays, XLOOKUP, LET – New Excel Features
Dynamic Array Charts
- Dynamic Charts Using Dynamic Arrays
- Dynamic Arrays, Names, and Charts
- Dynamic Arrays, Names, and Multi-Tier Categories
- Dynamic Array Histogram
- LAMBDA Function to Build Three-Tier Year-Quarter-Month Category Axis Labels
Dynamic Charts
- Dynamic Charts
- Easy Dynamic Charts Using Lists or Tables
- Dynamic Charts in Excel 2016 for Mac
- Dynamic Chart using Pivot Table and Range Names
- Dynamic Chart using Pivot Table and VBA
- Dynamic Ranges to Find and Plot Desired Columns
- Split Data Range into Multiple Chart Series without VBA
- VBA to Split Data Range into Multiple Chart Series
- Dynamic Chart Source Data (VBA)
- Dynamic Chart with Multiple Series
- Display One Chart Dynamically and Interactively
Error Bars
- Error Bars in Excel 2007 Charts
- Custom Error Bars in Excel Charts
- Floating Bars in Excel Charts
- Error Bar Gantt Chart
- Callout Labels with Error Bars
- Step Charts in Excel
- Swimmer Plots in Excel
- High-Low Line Alternatives in Excel Charts
- Custom Axis Labels and Gridlines in an Excel Chart
- Add a Horizontal Line to a Column or Line Chart: Error Bar Method
- Add a Vertical Line to a Column or Line Chart: Error Bar Method
- Hour by Hour Flow Chart
- Revenue Chart Showing Year-Over-Year Variances
Floating Bars
- Floating Bars in Excel Charts
- Error Bar Gantt Chart
- Salary Chart: Plot Markers on Floating Bars
- Low-Medium-High Charts
- Excel Waterfall Charts (Bridge Charts)
- Excel Box and Whisker Diagrams (Box Plots)
- Microsoft Excel Stock Charts
- Candlestick Alternative: Individually Colored Up-Down Bars
- Swimmer Plots in Excel
- Colored Vertical Band Across an Excel Chart
- Stacked Column Charts that Cross the X Axis
- See Gantt Charts
Gantt Charts
- Gantt Charts in Microsoft Excel
- Gantt Chart with Nice Date Axis
- Error Bar Gantt Chart
- Repeated Gantt Chart to Track Players’ Ice Time
- Gantt Chart for Repeated Tasks
- Easier Gantt Chart for Repeated Tasks
- Gantt Chart with Repeated Tasks via Excel XY Chart
Gaps
- Plot Blank Cells and #N/A in Excel Charts
- Mind the Gap – Charting Empty Cells (obsolete)
- Another approach to plotting gaps in Excel charts (obsolete)
- VBA Approaches to Plotting Gaps in Excel Charts (obsolete)
- Area Chart With Gap (obsolete)
Histograms
- Dynamic Array Histogram
- Histogram With Normal Curve Overlay
- Histograms Using Excel XY Charts
- Histogram Using XY and/or Area Charts
- Filled Histograms Using Excel XY-Area Charts
- Histogram on a Value X Axis
- Histogram with Actual Bin Labels Between Bars
- Peltier Tech Histogram
Interactive Charts
Legends
- Order of Series and Legend Entries in Excel Charts
- Legend Entry Tricks in Excel Charts
- Legends in Excel Charts – Formats, Size, Shape, and Position
- Double Legend in a Single Chart
- Slim Down Those Fat Legend Keys
Marimekko Charts
- Marimekko Charts
- The Problem with Marimekkos
- Marimekko Replacement – Overlapping Bars (Easy)
- Marimekko Replacement – Overlapping Bars (Hard)
- Marimekko Replacement – 2 by 2 Panel
Mathematics
Moving Averages
- Lambda Moving Average Formulas
- Lambda Moving Average Formulas
- Improved Excel Lambda Moving Average
- Excel Lambda Moving Average
Panel Charts
- How to Build a Simple Panel Chart
- How to Build a 2×2 Panel Chart
- Easy Two-Panel Column Chart in Excel
- Trellis Plot Alternative to Stacked Bar Chart
- Bar-Line Chart with Secondary Axis or Two Panels
- Alternatives to a 3D Bar Chart
Pivot Tables and Charts
- Using Pivot Tables in Microsoft Excel
- Referencing Pivot Table Ranges in VBA
- Pivot Table Conditional Formatting with VBA
- Grouping by Date in a Pivot Table
- Clean Up Date Items in An Excel Pivot Table
- Explore Your Data with Pivot Tables
- Preliminary Data Exploration with Excel Pivot Tables
- Prepare Your Data in a Chart Staging Area
- Working with Pivot Charts in Excel
- Pivot Chart Formatting Changes When Filtered
- Copy a Pivot Table and Pivot Chart and Link to New Data
- Making Regular Charts from Pivot Tables
- Update Regular Chart when Pivot Table Updates
- Create and Update a Chart Using Only Part of a Pivot Table’s Data
- Dynamic Chart using Pivot Table and Range Names
- Dynamic Chart using Pivot Table and VBA
- Using Pivot Table Data for a Chart with a Dual Category Axis
SERIES Formula
- The Excel Chart SERIES Formula
- Change Series Formula – Improved Routines
- How to Edit Series Formulas
- Simple VBA Code to Manipulate the SERIES Formula and Add Names to Excel Chart Series
- Edit Series Formulas
- Add One Trendline for Multiple Series
- Unlink Chart Data
Slope Charts
- Slope Chart with Data Labels
- How to Make Slope Graphs in Excel
- Funny Conclusions from a Dual Pie Chart
Statistical Process Control
- Watching my Weight with SPC (Statistical Process Control)
- SPC Approach to Browser Stats
- PBCharts Inflation Analysis
- Polynomial Fit vs. Statistical Process Control
- Use a Chart to See Patterns in Your Data
- Types of Control Charts
- Introducing Control Charts (Run Charts)
- Statistical Process Control
Statistics
- Pareto Charts in Excel
- Fill Under a Plotted Line: The Standard Normal Curve
- Excel Box and Whisker Diagrams (Box Plots)
- See Histograms
- See Statistical Process Control
- See Trendlines and Regression
Tables
Trendlines and Regression
- Trendlines and Chart Types in Excel
- Add One Trendline for Multiple Series
- Trendline Calculator for Multiple Series
- Trendline Fitting Errors
- Choosing a Trendline Type
- Plot Two Time Series and Trendlines with Different Dates
- Polynomial Fit vs. Statistical Process Control
- Moving Averages
- Stacked Column Chart with Stacked Trendlines
- Deming Regression
- Deming Regression Utility
- LOESS Smoothing in Excel
- LOESS Utility for Excel
