Index -- Jon Peltier's* Web Site -- Chart Pages

Visit Jon's Home Page -- http://peltiertech.com/index.html
Visit Jon's Blog -- http://peltiertech.com/WordPress/

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 Maker Line and Fill Effects in Excel Charts Using VBA
Box and Whisker Plots Lines, Run Chart with Mean and Standard Deviation
Brickyard Chart Menu, Chart Size on
Broken Y Axis Minimum and Maximum, Special Format
Bubble Chart Bubble Sizes, Control Naming Charts
Category Axis, Vertical Number Formats in Microsoft Excel
Change Series Formulas Outliers, Add Labels to Points that are Off Scale
Chart by Combo Box or Checkbox Panel Chart with Different Panels  
Chart Series Formula Panel Chart with Vertical Panels
Chart Size on your Menu  Pivot Tables and Pivot Charts, Intro
Chart Source Data Plotted Point, Get Information
Chart Type, Select with List Box or Drop Down

Probability Chart

Chart Types 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, Links  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 that Cross the X Axis
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
   
   

*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 the recently published Excel Charts, and has an extensive web site (http://peltiertech.com), which has an emphasis on working with Excel charts.

       Home     Excel Tips     Excel Files      Blog    Contact

 

RSS Feed

 

 

 

The Excel Store