Search Contextures Sites
Excel Charts -- Links to Samples and Articles
Jon Peltier's site - Chart Samples and Tutorials
Rob Bovey's XY Chart Labeler - Free Add-in
Andy Pope's site - Chart Samples and Tutorials
Tushar Mehta's site - Chart Samples and Tutorials
Stephen Bullen's site - Chart Samples to download
John Walkenbach's site - Chart Samples to download
Chandoo's site - Charting Tips
Peltier Technical Services, Inc. Charting Utilities Instead of creating complex Excel charts from scratch, you can use a charting utility add-in to automate the job for you. You'll save time and reduce frustration, and you will be impressed by how quickly and easily you can create complex Excel charts.
MS Knowledgebase Articles - Excel Charts General
Glossary of Charting Terminology
-definitions of basic terms used in Excel charts, such as data series, error bars and trendlines.
Overview of Built-in Chart Types
-describes all types of Excel charts and what data is best represented in each of the chart types
How Chart Axis Limits Are Determined
-explains how the min and max limits for axis scales in Excel charts are computed
Using Defined Names to Automatically Update a Chart Range
-Excel charts can be automatically updated as you add new information
Create a Gantt Chart Using Hours as the Scale
-use a Gantt Chart to show the progress of a project
Creating Charts with Multiple Groups of Stacked Bars
-Excel charts can appear to have more than one stack per category
Create a BoxPlot/Box & Whisker Chart
-Excel charts don't include box plots, but you can create a reasonable representation of the box plot type of chart
MS Knowledgebase Articles - Excel Charts VBA
Visual Basic Module to Create a Gantt Chart
-programmatically generate this type of chart
Automatically Set Min and Max Scale for Y-Axis
-use code to determine the min and max values in Excel charts data
Programmatically Print All Embedded Charts on Worksheet
-Each chart is printed on a separate page
Macro to Extract Data from a Chart
-retrieve data from Excel charts, even when the source data has been lost
How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel
-there is no built-in command that automatically attaches text labels to data points in an xy (scatter) or Bubble chart.
MS Knowledgebase Articles - Excel Chart Issues
Scatter Chart Series Lines and Trendlines are Not Printed Correctly
-lines in Excel charts may appear to move from their original location
"Run-time error '16': Expression too complex"
-Error message when you run a VBA macro to adjust the charts on an Excel 2007 worksheet
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Contextures Inc., Copyright ©2016
All rights reserved.
Last updated: April 6, 2016 10:55 AM