Jon Peltier’s Excel Page – Microsoft Excel Tips and Tricks
- Excel Menus and Command Bars
- Using Excel with Other Office Applications
- Number Formats
- Hyperlinks in Excel
- Other Excel Tips and Tricks – These are a few miscellaneous tricks and techniques I’ve learned.
- Visual Basic Scripting (VBS) – simple examples – VBS is a watered down version of VB/VBA that can run stand-alone on
a machine with Windows Scripting Host installed. It must be hard to
find a computer without WSH nowadays, because the last few versions of
IE and Windows install WSH by default.
Excel Charts and Charting
Charting Tutorial – Making Charts in Microsoft Excel
A tutorial section that answers many common questions about making charts in Excel.
- Introduction
- Getting Started
- Chart Wizard
- Chart Types
- Source Data
- Chart Names
- Number Formats in Excel
- Custom Series Formatting
- Error Bars in Excel Charts
- Charts and VBA
Special How-To Topics:
- X Axis: Category or Value?
- Roll Your Own Combination Chart
- Delink Chart Data
- Charting Data From Different Sheets
- Quick Chart VBA Examples
- Error Free VBA
Chart Formatting Techniques and Tricks
- Simple Conditional Charts
- Simple Conditional Charts – 2
- Special Format for Minimum and Maximum
- Chart with Colored Quadrant Background
- Colored Vertical Band
- Fix Chart Font Scaling
- Make Gridlines Square
- Squeeze Columns Together (Squeeze Out Blank Columns)
- Column Chart with Variable Width Columns
- Variable Width Column Charts
- Custom Series Formatting
- Columns on Two Axes
- Floating Column Charts
- Waterfall Charts
- Fancy Waterfall Chart
- Waterfall Charts that Cross the X Axis
- Custom Histograms
- Tornado Charts
- Clustered-Stacked Column Chart
- Number Formats in Excel
- Control Bubble Chart Bubble Sizes
Combination Charts
- Roll Your Own Combination Chart
- Add a Horizontal or Vertical Line to a Column or Line Chart
- Bar-Line Combination Chart
- Vertical Category Axis
- Stock Charts with Added Series
- Chart with Colored Quadrant Background
- Colored Vertical Band
- Box and Whisker Plots
- Speedometer Chart
- Squeeze Columns Together (Squeeze Out Blank Columns)
- XY Scatter Area Charts
- Combine Clustered Columns with Clustered Lines
- Clustered-Stacked Column Chart
- Gantt Charts in Microsoft Excel
- Dynamic Charts
- Worksheet Controls for Chart Interactivity
- VBA Chart Interactions
- X Axis: Category or Value?
- Vertical Category Axis
- Tertiary Y Axis
- Arbitrary Axis Scale
- Arbitrary Gridlines
- Arbitrary Gridlines, Take Two
- Probability Chart
- Reciprocal Axis Chart
- Stacked Line Chart
- Stacked Charts With Vertical Separation
- Switch X and Y
- Creating Exponential Notation Axis Labels
- Squeeze Columns Together (Squeeze Out Blank Columns)
- Staggered Axis Labels
- Broken Y Axis
- Link Chart Axis Scale Parameters to Values in Cells
- Align X Axis to Y=0 on Two Y Axes
Dummy Series
- Vertical Category Axis
- Tertiary Y Axis
- Arbitrary Axis Scale
- Arbitrary Gridlines
- Arbitrary Gridlines, Take Two
- Probability Chart
- Reciprocal Axis Chart
- Speedometer Chart
- Squeeze Columns Together (Squeeze Out Blank Columns)
- Stock Chart with Left Tick Marker for Open Series
- Special Format for Minimum and Maximum
- Staggered Axis Labels
- Chart with Colored Quadrant Background
- Colored Vertical Band
- Floating Column Charts
- Waterfall Charts
- Fancy Waterfall Chart
- Waterfall Charts that Cross the X Axis
Contributed by fellow Excel MVP Debra Dalgleish. .
Stock Charts
- Stock Charts with Added Series
- Stock Chart with Left Tick Marker for Open Series
- Horizontal Stock Chart
- Box and Whisker Plots
- Probability Chart
- Dynamic Control Chart
- Histograms
- Custom Histograms
- Run Chart with Mean and Standard Deviation Lines
Miscellaneous Charts and Topics
- Delink Chart Data
- Protecting Charts
- Brickyard Chart
- Stacked Column Charts that Cross the X Axis
- Tornado Charts
VBA Charting Techniques
Popularity: 34% [?]
Related Posts: