- Good Chart Data
- How to Create Excel Charts
- 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
- 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?
- 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
- 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 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
- Better Pie Chart Data Labels
- Nice Bar Chart Data Labels
- Nice Bar Chart Data Labels Using VBA
- 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
- 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 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 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 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
- 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)
- 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
- 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
- Use VBA to Add a Chart
- Axis Scales
- Chart Events
- Conditional Formatting
- Data Labels
- Chart Data
- Pivot Tables
- Trendlines and Regression
- Working with Add-Ins and Macros
- Designing UserForms for Mac and Windows
