Search Contextures Sites

Excel Charts -- Links to Samples and Articles Excel Charts - Site Links 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 Pointy Haired Dilbert's site - Charting Tips Excel Charts - 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 your boss and clients 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

 

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright © 2009. All rights reserved.	Debra Dalgleish