Search Contextures Sites

Index to Jon Peltier's* Excel Chart Tutorials and Chart Utilities

Learn how to create Excel dashboards.

Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more.

 

 

Align (Overlay) Charts

Gantt Chart Links

Align X Axis to Y=0 on Two Y Axes

Gantt Charts in Microsoft Excel - Advanced Techniques

Arbitrary Axis Scale

Arbitrary Gridlines

Gridlines, Arbitrary, Take Two

Arbitrary Gridlines, Take Two

Gridlines, Make Square

Arbitrary Gridlines and Axis Labels

Histograms

Area Charts, XY Scatter

Histograms, Custom

Arrow, Use to Indicate Special Points

Horizontal Line, Add to a Column or Line Chart

Axes and Axis Tricks

Horizontal Stock Chart

Axes, Align X Axis to Y=0 on Two Y

Hyperlinks in Excel

Axes, Columns on Two

In Cell Charting with Worksheet Formulas

Axis Label Cut Off  

Interactive Chart Creation

Axis Labels, Staggered

Interactive Parallel Coordinates Chart 

Invert If Negative 

Axis Scale, Link Parameters to Values in Cells

Label Last Point

Axis, Vertical Category

Labels, Staggered Axis

Bar-Line Combination Chart

Labels, Add to Points that are Off Scale

Box and Whisker Chart Utility

Line and Fill Effects in Excel Charts Using VBA

Box and Whisker Plots

Lines, Run Chart with Mean and Standard Deviation

Brickyard Chart

Marimekko Chart Utility

Broken Y Axis

Menu, Chart Size on

Bubble Chart Bubble Sizes, Control

Minimum and Maximum, Special Format

Category Axis, Vertical

Naming Charts

Change Series Formulas

Number Formats in Microsoft Excel

Chart by Combo Box or Checkbox

Outliers, Add Labels to Points that are Off Scale

Chart Series Formula

Panel Chart with Different Panels  

Chart Size on your Menu 

Panel Chart with Vertical Panels

Chart Source Data

Pivot Tables and Pivot Charts, Intro

Chart Type, Select with List Box or Drop Down

Plotted Point, Get Information

Chart Types

Probability Chart

Chart Utilities

Property Procedures - Forms

Chart Wizard

Protecting Charts

Charting Data From Different Sheets

Quadrant Background, Chart with Colored

Clustered Columns with Clustered Lines

Reciprocal Axis Chart

Clustered-Stacked Column Chart Utility 

Resizing and Moving Charts in VBA

Colored Quadrant Background, Chart with

Run Chart with Mean and Standard Deviation Lines

Colored Vertical Band

Series Formulas, Change

Column Chart, Dynamic

Solver in VBA, Using  

Column Chart with Horizontal Line Segments

Source Data

Column Charts, Floating

Speedometer Chart

Columns on Two Axes

Speedometer Chart XP

Columns, Squeeze Together

Squeeze Columns Together

Combination Chart, Roll Your Own

Stacked Charts With Vertical Separation

Combination Chart, Bar-Line

Stacked Column Charts that Cross the X Axis

Combination Charts

Stacked Line Chart

Combination Clustered Columns with Clustered Lines

Staggered Axis Labels

Combination Chart for Monthly Temperatures, Column

Statistics, Charts for

Command Bar, Custom Drawing

Step Charts in Microsoft Excel

Conditional Charts, Simple

Stock Chart with Left Tick Marker for Open Series

Conditional Charts, Simple - 2

Stock Chart, Horizontal

Consolidate Text Data for Charting

Stock Charts

Control Chart, Dynamic

Stock Charts and Other Line Chart Tricks

Custom Histograms

Stock Charts with Added Series

Custom Chart Type, Creating a

Superscript - Creating Exponential Notation Axis Labels

Custom Series Formatting

Switch X and Y

Delink Chart Data

Temperatures, Column Combination Chart for Monthly

Deviation Column Charts 

Tertiary Y Axis

Different Sheets, Charting Data from

Text Data, Consolidate for Charting

Dimensions, Align Chart

Tornado Chart

Dot Plots and Utility

Tutorial, Charting

Drop Lines in Excel Charts

Variable Width Columns, Column Chart with 

Dummy Series

Variable Width ColumnCharts, Links 

Dynamic and Interactive Charts

VBA Charting Techniques

Dynamic Chart

VBA Examples, Quick Chart

Dynamic Chart -- Last 12 Months

VBA, Error Free

Dynamic Chart Links

VBA, Charts and

Dynamic Column Chart

Dynamic Control Chart

Vertical Category Axis

Dynamic Normalized Ranges, Charting

Vertical Line, Add to a Column or Line Chart

Equation, Plot an  

Waterfall Charts

Error Bars in Excel Charts

Waterfall Charts, Fancy

Exponential Notation Axis Labels, Creating

Waterfall Charts Utility

FAQ, Charting

X Axis: Category or Value?

Fill Color Between Lines in a Chart, Apply

XY Area Chart: Fill Below an XY Series

Fix Chart Font Scaling

XY Area Chart: Fill Between XY Series

Floating Column Charts

XY Chart Utility, Quick

Font Scaling, Fix Chart

XY Scatter Chart Variations

Forms, Property Procedures

XY Scatter Area Charts

 

 

Jon's Chart Utilities -- Peltier Technical Services, Inc. Charting Utilities

*Microsoft Excel MVP Jon Peltier is a metallurgical engineer, with 23 years experience in Research and Development. His academic credentials include a Doctor of Science in Metallurgy, with a minor program in Statistics. Jon was Technical Editor for Excel Charts , and he has an extensive web site, with an emphasis on Excel charts and Excel chart utilities.

Disclosure: I earn a small commission if you purchase products through links on this site.

 

Learn how to create Excel dashboards.

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright 2011
All rights reserved.