Categorical Archive of the PTS Blog

Amusement

• Excel Error Messages
• Funny Math in Wall Street Journal Pie Charts
• My Favorite Pie Chart
• Watermelon Chart
• The Downside of Working in a Cubicle
• John Walkenbach's Lime Crop
• Spike in Blog Traffic
• Pie Charts Must Die
• Copy and Paste Charts at Zooms other than 100%
• Interesting Link for 10-April-2009
• Pie Chart for Pi Day
• Stick a Chart in it
• Paper Pie Charts?
• 3D Pie Charts
• Back in the Swing
• Weekend Fun: New iGoogle Interface Unpopular
• Dial Gauge
• Time is on My Side
• OT Friday: GraphJam
• OT: Alternative Graph Interpretation in the Real World
• OT: Charting to Achieve Fitness Goals

Books

• Excel Books

Chart Axes

• Chart UDF to Control Axis Scale
• Histogram With Normal Curve Overlay
• Axis Labels on Small Charts
• Column Chart with Category Axis Labels Between Columns
• Simple XY Quad Chart Using Axes as Quadrant Boundaries
• Reciprocal Chart Axis Scale
• Secondary Axis as Percentage of Target
• Axis Labels That Don't Block Plotted Data
• Histogram on a Value X Axis
• Histogram with Actual Bin Labels Between Bars
• Individually Formatted Category Axis Labels
• Custom Axis Labels and Gridlines in an Excel Chart
• Calculate Nice Axis Scales in Your Excel Worksheet
• Calculate Nice Axis Scales in Excel VBA
• How Excel Calculates Automatic Chart Axis Limits
• Consistent Axis Scales Across Multiple Charts
• Select Meaningful Axis Scales
• You Have 1 New Notification On Klout!
• Broken Y Axis in an Excel Chart
• Fake Line Chart (Dummy XY Series for X Axis)
• Why Are My Excel Bar Chart Categories Backwards?
• Custom Axis, Y = 1, 2, 4, 8, 16
• Tax the Rich, or Deceptive Axis Scales
• Individually Formatted Dual Category Labels
• Category Labels That Don't Overlap the Data
• Date Axis with Centered Years
• Add Percentages on the Secondary Axis
• Logarithmic Axis Scales
• Choice of Category Axis Order
• Excel Category Axis Types
• Category Axis Tricks for Line and Area Charts - 2
• Category Axis Tricks for Line and Area Charts - 1
• Individually Formatted Category Axis Labels
• Chart with a Dual Category Axis
• Secondary Axes that Work - Proportional Scales
• Secondary Axes in Charts

Chart Busters

• Multiple Line Charts by Category
• Chart Busters: Fix the Heat Map Donut Chart
• Wow! Heat Map Donut Chart!
• Funny Conclusions from a Dual Pie Chart
• Chart Busters: The Economist Doesn't Read Forbes
• Chart Busters: What Planned Parenthood Actually Does
• Chartbusters: Not Another Bad Pie Chart???
• Charting 2011 Major League Baseball Attendance
• Chart Busters: Pie Charts Can't Show Trendlines
• Chartbusters: Reworking a New York Times Box of Donuts
• Bar Chart Value Axis Scale Must Include Zero
• Two Ugly Real Economic Growth Charts
• Z Chart to Monitor Web Traffic
• Recovery by Sector of S&P 500 Companies (Guest Post)
• Charting NBC Olympic Coverage
• Reforming a Health Care Reform Chart
• Monthly And Cumulative Spending Charts
• Extra Distortion in a Pie Chart
• Dating Site Photo Effectiveness
• Use Dot Plots for Better Categorical Comparisons
• Yikes! Another Pie Horror Show
• Graphing The Cost of Health Care
• Better Chart of the Day
• Comparison of Search Share, September and October 2009
• Misguided "Professional" Charting Tutorial
• Climate Change Survey Results
• What's Worse Than A Pie Chart?
• Relief Pitching - Chart Busters
• Composite Baseball Player Evaluation
• Analysis of Baseball Attendance - Chart Busters
• NPR Analysis by Chart Busters
• Visualizing Weekly Data - Chart Busters
• Which Pie is Better?
• Political Pie Charts
• Chart Busters - Compare Employee Sales
• Chart Busters Calorie Chart
• New Feature: The Chart Doctor

Chart Types

• Repeated Gantt Chart to Track Players' Ice Time
• Step Charts in Excel
• Cycle Plots in Excel
• Risk Matrix Charts in Excel
• Gantt Charts in Microsoft Excel
• A Comparison of Peltier Tech and Excel Box Plots
• The New Waterfall Chart in Excel 2016
• Diverging Stacked Bar Charts
• Paired Waterfall Chart
• Make Technical Dot Plots in Excel
• Plot Values Along the Axis of an Excel Chart
• Bullet Charts in Excel (updated and simplified)
• Polar Plot in Excel
• Swimmer Plots in Excel
• Dot Plots in Microsoft Excel
• Column Chart with Primary and Secondary Axes
• Histogram Using XY and/or Area Charts
• How To Make Cycle Plots Using Excel Charts
• Bar-Line Chart with Secondary Axis or Two Panels
• Charting Survey Results
• Alternatives to a 3D Bar Chart
• Shaded Quadrant Background for Excel XY Scatter Chart
• How to Make Slope Graphs in Excel
• How to Make Arrow Charts in Excel
• Excel Fan Chart Showing Uncertainty in Projections
• OHLC Stock Chart with Tick Marks in Microsoft Excel
• Easy Two-Panel Line Chart in Excel
• Easy Two-Panel Column Chart in Excel
• Poor Man's Sparklines in Microsoft Excel
• Who's to Blame for the Mess in Washington? Analysis of Chart Types
• Excel 3D Charts: Charts with No Value
• Excel 2010 Chart Types
• Clustered and Stacked Column and Bar Charts
• Excel Waterfall Charts (Bridge Charts)
• Excel Box and Whisker Diagrams (Box Plots)
• Panel Chart Comparing Browser Power Consumption
• Filled Histograms Using Excel XY-Area Charts
• Histograms Using Excel XY Charts
• Multiple Horizontal Bullet Graphs in Excel
• How to Make Horizontal Bullet Graphs in Excel
• Gantt Chart with Repeated Tasks via Excel XY Chart
• Easier Gantt Chart for Repeated Tasks
• Gantt Chart for Repeated Tasks
• How to Make Vertical Bullet Graphs in Excel
• Stacked Bar Chart Alternatives
• Area Chart With Gap
• Charting Breakdown of Ads in a Television Show
• Crosstab Heat Map
• Contour and Surface Charts in Excel 2007
• Pareto Charts
• Pie Chart Quiz
• You Say "Pie", I Say "Bar"
• I Keep Saying, Use Bar Charts, Not Pies
• Exploded Pie Chart Replacement
• Selecting a Meaningful Series Order
• Plot Two Time Series And Trendlines With Different Dates
• Simple Box Plots
• Simple Bar Chart Beats Complex Multiple Sized Pies
• Radar Charts are Ineffective
• Variable Width Column Charts (Cascade Charts)
• Clustered-Stacked Column Chart with Target Line
• Stock Charts in Excel 2007
• Funnel (Tornado) Chart
• Pie Chart Plotting Deficiency
• Antibiotic Effectiveness - A Study of Chart Types
• Growth Rates in a Panel Chart
• Spiraling Down the Drain
• Deceptive Decline in Interest Rates
• Scary Info Graphic
• How to Make a Donut-Pie Combination Chart
• Leave the Donuts for the Cops, and Stick with the Bars
• An Undistorted Election Results Map
• Redrawn Electoral Maps
• Challenge - Show Market Share Changes
• Spider Chart Alternatives
• Sample Parallel Coordinate Chart
• US Employment Slump Chart - How To
• US Employment Slump Chart
• Chandoos' 6 Favorite Charts
• Stacked Bar Chart Improvement
• Stacked vs. Clustered
• Microsoft Chart Advisor
• Radar Around the Clock
• Rock Around The Clock
• Order of Points in XY and Line Charts
• In-Cell Bullet Charts
• California Majority Party by County
• A Gauge that Works?
• Chart Selection Guide
• Peltier Goes Bar Hopping
• Peltier Loves Pie
• On Seth Godin on Charts
• Bar graphs vs. Pie charts
• Seth's Three Laws of Great Graphs
• Ineffective Chart - Partition Chart Revisited (Defragged)
• Re: Graphical Propaganda
• Line Charts vs. XY Charts
• Ineffective Chart - Partition Chart
• Bad Graphics - Funnel Chart
• Close Races 2
• Close Races
• Line Chart vs. Step Chart
• Stacked Area Chart Challenge
• Candlestick Alternative: Individually Colored Up-Down Bars
• Bad Graphics - Stacked Pyramid Chart
• The Perils of Being in 3D
• Clustered Bars as an Alternative to Stacked Bars or Bubbles
• Tornado Charts and Dot Plots

Charting Principles

• Chart a Wide Range of Values
• Floating Bars in Excel Charts
• Colors Aren't Needed to Make Data Easier to Read
• Excel Charting Dos and Don'ts
• Anybody but Romney Snakeskin Chart
• Excel Plotted My Bar Chart Upside-Down
• Series Lines: Useful or Chart Junk?
• Sales "Funnels"
• Effective Graphical Comparison of Murder and Suicide Rates
• Line Chart For Unequal Intervals
• Custom Error Bars in Excel Charts
• Box Plot of Values Against Limits
• Plotting Values Against Limits
• Copy Chart and Data and Preserve Links
• Highlight a Series with a Click or a Mouse Over
• Adding Excel Chart Data
• Which Blogging Platform Do You Use?
• Smooth Talking Lies
• Chart Series Data Highlighting
• Chart Source Data Highlighting
• Stack Columns In Order Of Size
• Pie for Dessert Again?
• Charting Best Practices in PowerPoint
• Magazine Quality vs. Informative Infovisualization
• A Visual Comparison of China and the United States
• Draw an Axis With Tick Marks But No Line
• Replacement for an Oil Price Radial Chart
• Map Bubble Chart of Store Closings
• Make a Copied Chart Link to New Data
• The Problem with Marimekkos
• Plot Two Time Series With Different Dates
• Wired's Weird Graphics Department
• Bad Bar Chart Practices, or Send in the Clowns
• Antibiotic Effectiveness Charting - Revisited
• Edward Tufte and Business Charts
• Ten Chart Design Principles: Guest Post
• The Purpose of Charting
• Gradients, Fills, and Shadows, Oh My
• Plotting Measured Data
• What Goes into the Price of Gas?
• Step Chart Without Risers
• Column Chart to Replace Multiple Pie Charts
• Pie Chart Rounding in Excel

Combination Charts

• Revenue Chart Showing Year-Over-Year Variances
• Horizontal Line Behind Columns in an Excel Chart
• Add a Horizontal Line to an Excel Chart
• Bar-Line (XY) Combination Chart in Excel
• Salary Chart: Plot Markers on Floating Bars
• Fill Under or Between Series in an Excel XY Chart
• Another Simple Baseline for Excel Column Chart
• Simple Baseline for Excel Column Chart
• Fill Under a Plotted Line: The Standard Normal Curve
• Categorical XY Chart with Highlighted Categorical Ranges
• Excel Chart With Colored Quadrant Background
• Build a Bar-Line Combination Chart
• Two Color XY-Area Combo Chart - Guest Post
• How to Build a Simple Panel Chart
• Radar-XY Combination Chart
• Adding an Arbitrary Target
• Add a Target Line
• Integer Values on Line Chart Category Axis
• Line-XY Combination Charts

Conferences

• Unlock Excel - Two Down, One to Go
• The Return of Unlock Excel
• Upcoming 2017 Conferences and Training
• Excel Summit South 2016 Summary

Dashboards

• Using Worksheet Controls to Highlight Selected Data in an Excel Chart
• Not Gauges Again!
• Animated Dashboards?
• Review of Xcelsius Present
• Nice Dashboard Examples
• Dashboards
• Charting Seasonal Sales Data in Excel using Cycle Plots

Data Labels

• Apply Custom Data Labels to Charted Points
• Label Totals on Stacked Column Charts

Data Techniques

• Add One Trendline for Multiple Series
• Importing and Cleaning Data with Power Query
• Ctrl+Select in Excel Gets Smart
• Plot Blank Cells and #N/A in Excel Charts
• Check Your Data: Is It Numeric or Text
• Multiple Time Series in an Excel Chart
• Multiple Series in One Excel Chart
• Copy Chart to New Sheet and Link to Data on New Sheet
• Solve xkcd's Velociraptor Problem with Excel
• Select Data to Display in an Excel Chart With Option Buttons
• Chart Partial Range Between Variable Endpoints
• Clean Up Date Items in An Excel Pivot Table
• Data Smoothing Perils (Series Lines Follow-Up)
• Excel Interpolation Formulas
• Area Under a Fitted Curve
• Copy a Pivot Table and Pivot Chart and Link to New Data
• Time Trials of Approaches to Measure Minimum and Maximum Chart Values
• Deming Regression
• Mind the Gap - Charting Empty Cells
• AutoFilter Tricks
• Calculating Wind Direction per DDoE
• Prepare Your Data
• LOESS Smoothing in Excel
• How to Edit Series Formulas
• SOLVER - Optimization Approach to a Simple Physics Problem
• Goal Seek - Optimization Approach to a Simple Physics Problem
• Regression Approach to a Simple Physics Problem
• Graphical Approach to a Simple Physics Problem
• Highlighted Chart Source Data
• Connect Two XY Series
• Split Data Range into Multiple Chart Series without VBA
• A Linked Table to Sort Data for Charting

Dynamic Charts

• Dynamic Charts in Excel 2016 for Mac
• Simple Interactive Charts in Excel
• Easy Dynamic Charts Using Lists or Tables
• Dynamic Chart with Multiple Series
• Dynamic Chart Review
• Interactive Charts with Checkboxes and Formulas
• Accordion Chart for Jorge
• Gapminder For Excel II
• Display One Chart Dynamically and Interactively
• Ballistics Animation
• Presidential Demographics
• Rolling Wheel Animation
• Gas Prices - Interactive Time Series
• Gapminder for Excel
• Gas Prices - Animated Bar Chart for Excel 2
• Gas Prices - Animated Bar Chart for Excel
• Easier Interactive Multiple Line Chart
• Interactive Multiple Line Chart
• Re: Abortion Ratios 1980-2003
• Update Regular Chart when Pivot Table Updates
• Dynamic Chart Source Data
• Physics Lesson
• Dynamic Charts
• Dynamic Chart using Pivot Table and VBA
• Dynamic Chart using Pivot Table and Range Names
• Dynamic Ranges to Find and Plot Desired Columns

Example Charts

• Marimekko Replacement - 2 by 2 Panel
• Marimekko Replacement - Overlapping Bars (Hard)
• Marimekko Replacement - Overlapping Bars (Easy)
• Marimekko Charts
• How to Build a 2x2 Panel Chart
• Better Charts of Graduation Rate and Federal Spending
• Conditional Stacked Clustered Column Chart with Targets

Excel 2007

• Dialog Design Inefficiencies in Excel 2007
• Blue Ribbon Interface
• Connect Two XY Series with Arrows - 2007 Error
• Label Last Point for Excel 2007
• Error Bars in Excel 2007 Charts
• What happened to my favorite Excel 2003 Chart feature?
• Why I don't like Excel 2007 charts
• Excel 2007 Recalculates Slowly
• Excel 2007 Chart Performance - Revisited
• Poor Charting Performance in Excel 2007
• Installing an Add-In in Excel 2007
• Excel 2007 Regression Error - Fixed in SP1
• Changes to Charting in Excel 2007
• A Belated Review of Excel 2007

Excel 2010

• Sparklines For Excel vs. Excel 2010 Sparklines (Guest Post)
• Chart Redrawing Performance of Excel 2003 and 2010
• Improved Macro Security Warning in Excel 2010
• Chart Point Limits in Excel 2010
• Sparklines and Data Bars in Excel 2010
• My First Look at Excel 2010

Excel 2013

• Intelligent Excel 2013 XY Charts
• My First Excel 2013 Chart

Excel 2016

• Microsoft Releases Excel 2016 for Windows
• Office 2016 For Mac Is Here (well...)

Excel Features

• Threaded Comments in Excel
• Built In and Custom Lists in Excel

Excel Oddities

• Excel Error Messages
• Series Order Effects When Applying a Chart Template

Formatting

• Properties Follow Chart Data Point
• Chart with Actual Solid Lines and Projected Dashed Lines
• Slim Down Those Fat Legend Keys
• Connect Two XY Series with Arrows
• Highlight Min and Max Data Points in an Excel Chart
• Stick a Shape to a Point in an Excel Chart
• Removing Recent Colors from Microsoft Excel
• Error Bar Ideosyncrasy
• Highlight a Specific Data Label in an Excel Chart
• Color Plotted Points to Match Cells
• Multiple Width Overlapping Column Chart
• Create a Heat Map Using Excel's Conditional Formatting
• Using Colors in Excel
• Color Vision Issues with Heat Map Donut Charts
• Column Chart Gridlines Cutting Through Bars
• Conditional Formatting of Lines in an Excel Line Chart Using VBA
• Conditional Formatting of Excel Charts
• Excel Charts With Horizontal Bands
• Excel Chart With Irregular Horizontal Bands
• Text Labels on a Vertical Column Chart in Excel
• Text Labels on a Horizontal Bar Chart in Excel
• Invert if Negative in Excel 2007
• High-Low Line Alternatives in Excel Charts
• Conditional XY Charts Without VBA
• Add Individual Target Lines To Each Cluster in a Column Chart
• Logarithmic Axes in Excel Charts
• Excel Chart Color Update
• Hide Series Data Label if Value is Zero
• Mike Alexander's Favorite Chart Labeling Tricks (Guest Post)
• Double Legend in a Single Chart
• Order of Legend Entries in Excel Charts
• Legend Entry Tricks in Excel Charts
• Legends in Excel Charts - Formats, Size, Shape, and Position
• Show Two Groups of Data in One Chart
• Why You Should Use PNG and not JPEG
• 9 Steps to Simpler Chart Formatting
• Overlapped Bar Chart - Thinner Bars in Front
• Overlapped Bar Chart - Longer Bars in Back
• Area Chart - Invert if Negative
• Image File Type Comparison of Exported Charts
• Link Chart Text to a Cell
• Highlight Certain Time Periods in a Chart
• Magazine Quality Chart (Economist)
• Using Colors in Excel Charts

General

• Can You Answer This Quora Question?
• Ctrl+Select in Excel Gets Smart
• Microsoft Excel Charting Survey
• VB Password Prompt when Closing Excel
• Peltier Tech Update December 2015
• New Survey: What Spreadsheet Programs Do You Use?
• Survey: What Version of Excel Do You Use?
• Getting Answers For Your Excel Questions
• Why Do We Love Pie Charts?
• What's a Dashboard, Anyway?
• Excel Dashboard Training
• Some Comments on Dot Plots (Guest Post)
• New Series: You Asked For It
• Logarithmic Axes in Excel Charts
• Context Menu Key
• Pardon the Interruption
• New Computer
• OT: Web Meeting Software
• Three New Books
• Virtual Globes
• Callout Labels with XY Line Segments
• Callout Labels with Error Bars
• Pizza Pie
• Happy 200th Birthday to a Couple of Giants
• Practical Uses for a Box Plot
• Easy as 1-2-3
• Various Visualizations
• Decline (XKCD)
• Hide Your Data in an Interactive Onion Chart
• Bissantz Ponders
• How do you display a lopsided distribution?
• My Customized Excel Toolbars
• Pie Chart Traffic Light
• Book Review: Pro Excel 2007 VBA
• A Retrospective on Charting
• PTS Blog Inaugural Post

Guest Post

• Another approach to plotting gaps in Excel charts
• Guest Post: The ‘Fiscal Cliff’ Explained in Charts: A Critical Review
• Excel, Free Rice and MMA
• Programming Excel 2007 and Excel 2010 AutoShapes with VBA (Guest Post)

Links

Pivot Tables

• User Voice Fixes Pivot Table Default Settings
• Working with Pivot Charts in Excel
• Pivot Tables in Microsoft Excel: Links
• Using Pivot Tables in Microsoft Excel
• Pivot Table Resources
• Pivot Chart Formatting Changes When Filtered
• Referencing Pivot Table Ranges in VBA
• Explore Your Data With Pivot Tables
• Making Regular Charts from Pivot Tables
• Grouping by Date in a Pivot Table
• Using Pivot Table Data for a Chart with a Dual Category Axis

Rant

• Periodic Table of What??
• Does Excel "Suck"?
• CNet Expert on Excel
• I guess it's supposed to be funny

SPC

• SPC Approach to Browser Stats
• Types of Control Charts
• Use a Chart to See Patterns in Your Data
• Introducing Control Charts (Run Charts)
• Statistical Process Control

Statistics

• Quartiles in the Peltier Tech Chart Utility
• Comparison of Values from All Hinge and Quartile Methods
• Interpolation Methods of Determining Quartiles
• Hinge Techniques for Determining Quartiles
• Quartiles for Box Plots
• Main Effects and Interaction Plots
• Preliminary Data Exploration with Excel Pivot Tables
• Preliminary Data Exploration in Excel
• More Web Stats Madness
• Web Stats - June 2009
• Polynomial Fit vs. Statistical Process Control
• Macs vs. PCs
• Choosing a Trendline Type
• Trendline Fitting Errors
• Suicide Rates in Japan
• Seasonal Adjustment - Preliminary Approaches
• Moving Averages
• Bill James Interview on Freakonomics
• Statistics: Main Effects Plot

Tables

• Structured Referencing to Identify Parts of Excel Tables

Templates

• Excel Templates Demystified

Training

• Excel Dashboard and Visualization Bootcamp 2011

Utilities

• Trendline Calculator for Multiple Series
• Peltier Tech Charts for Excel Upgrade - April 2016
• Peltier Tech Charts for Excel 3.0
• Peltier Tech Utility 3.0 for Office 2016
• Peltier Tech Advanced Chart Utilities for Mac
• Peltier Tech Chart Utilities for Mac Excel - Advanced Edition
• The Advanced Chart Utility Is Here
• Peltier Tech Chart Utility for Excel - Advanced Edition
• Peltier Tech Chart Utility for the Mac
• Announcing: Peltier Tech Chart Utility
• Announcing Waterfall Chart Utility for Macintosh
• Change Series Formula - Improved Routines
• Trellis Plot Alternative to Stacked Bar Chart
• LOESS Utility - What the Buttons Mean
• Label Last Point - Updated Add-In
• LOESS Utility - Awesome Update
• Deming Regression Utility
• LOESS Utility for Excel
• BonaVista Releases Chart Tamer
• Indispensable Excel Utilities

VBA

• Reference SeriesCollection Item by Name or Index
• Extract Labels from Category Axis in an Excel Chart (VBA)
• Excel Scatter Bubble Chart Using VBA
• Designing UserForms for Mac and Windows
• Chart VBA Examples
• Interactive Formatting of a Chart Series with a Cell's Color
• Drop Buttons on VBA UserForm Controls
• Open CSV File and Chart CSV Data
• Export an Excel Chart to Word
• Export an Excel Chart to PowerPoint
• Click a Worksheet Cell to Change a Chart
• VBA: Assign Names to Chart Series
• VBA: An Advanced Add-in to Open a CSV File and Create Chart with Data Specified by User
• VBA: A Simple Tool to Open a CSV File and Create Chart with Data Specified by User
• Chart Events in Microsoft Excel
• Save and Retrieve Information With Text Files
• Link Excel Chart Axis Scale to Values in Cells
• VBA Approaches to Plotting Gaps in Excel Charts
• Create and Update a Chart Using Only Part of a Pivot Table's Data
• Simple VBA Code to Manipulate the SERIES Formula and Add Names to Excel Chart Series
• VBA Conditional Formatting of Charts by Value and Label
• Add Series to Existing Chart
• Format All Series The Same
• Alternative to Excel's Flaky RefEdit Control
• Build an Excel Add-In 6 – Interface for 2003
• Recorded Macro Error with Bubble and Stock Charts
• Build an Excel Add-In 5 - Tie the Code Together
• Build an Excel Add-In 4 - Create the Dialog
• Using RefEdit Controls in Excel Dialogs
• Build an Excel Add-In 3 - Auxiliary Modular Functions
• Build an Excel Add-In 2 - Enhanced Functionality
• Build an Excel Add-In 1 - Basic Routine
• List VBA Procedures by VBA Module and VB Procedure
• Robust VBA Save-As Technique
• Pivot Table Conditional Formatting with VBA
• Apply Chart Formatting to Other Charts
• Unspecified but Painfully Frustrating Error
• Stack Columns In Order Of Size With VBA
• Extend Range to Add New Series (VBA)
• Interactive Charts with Checkboxes and VBA
• Make Your Recorded Macro Independent of Which Sheet is Active
• Validation Functions
• VBA to Filter Chart Data Range
• Count Bold Cells in a Range
• Label Each Series in a Chart
• Extract Chart Data
• Calculating Easter
• Chart Event Class Module to Highlight a Series
• Chart Event to Highlight a Series
• Get Open or Save-As Filename
• File Name Functions
• Enhanced Export Chart Procedure
• Installing an Excel Add-In
• Export Chart as Image File
• Connect Two XY Series with Arrows (VBA)
• VBA to Split Data Range into Multiple Chart Series
• Forms Controls and ActiveX Controls in Excel
• Repurpose the Red X Close Button on a VBA UserForm
• Creating Charts in a Grid
• Arranging Charts in a Grid
• VB Editor Settings
• How To: Assign a Macro to a Toolbar or Menu
• How To: Assign a Macro to an ActiveX Control
• How To: Assign a Macro to a Button or Shape
• How To: Fix a Recorded Macro
• How To: Record Your Own Macro
• How To: Use Someone Else's Macro
• UDF to Calculate an Arbitrary Formula
• Quick VBA Routine: XY Chart with Axis Titles
• VBA Conditional Formatting of Charts by Series Name
• VBA Conditional Formatting of Charts by Value
• VBA Conditional Formatting of Charts by Category Label