You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates
:: Charts are what make Excel really tick. You can do a lot of really great stuff, and even some amazing stuff with Excel charts, so this category is for links to intermediate to advanced charting in Excel.
:: Topics may include professional formatting, linking chart features to cells, creating special types of charts, etc.


  Editor's Pick How to Create Bullet Graphs to Replace Gauges   www.exceluser.com
This article by Charley Kyd explains how to create professional bullet graphs that can be used instead of dashboard gauges to represent the same information more clearly and concisely.
Added: 07-15-2006 - Updated: 07-15-2006 - Hits total: 10875

  Editor's Pick Excel Dot Plot Charts   www.exceluser.com
"Compare Metrics by Category Using Excel Dot Plot Charts", an article by Charley Kyd, explains how to create and use dot charts in place of bar graphs.
Added: 07-15-2006 - Updated: - - Hits total: 6130

  Editor's Pick Excel Chart Tricks and Tutorials   peltiertech.com
Jon Peltier (Excel MVP) provides some great Excel chart tutorials and tricks for making them do some amazing things! A very cool site.
Added: 10-20-2004 - Updated: 10-20-2009 - Hits total: 18351

Automatic Chart Scale Harmonization   www.grbps.com
When comparing multiple graphs, it can be important to use similar scales. This article explains a method for automating chart scaling using some VBA code. [Article, PDF format]
Added: 06-02-2004 - Updated: 06-03-2004 - Hits total: 5867

Excel Chart Examples   OzGrid.com
Learn to create Excel charts with a difference. The Excel charting pages listed here show many different charting techniques, examples and solutions.
Added: 05-12-2006 - Updated: - - Hits total: 24781