Search Contextures Sites
Custom Search






Excel Charts -- Links to Samples and Articles

Recommended Websites

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

Charting Utilities

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

Get All the Excel News

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.



Privacy Policy


Contextures Inc., Copyright 2016
All rights reserved.



Last updated: April 6, 2016 10:55 AM