Peltier Technical Services, Inc.
 

Excel Charting Utilities | Custom Solutions | Training | Charts and Tutorials | PTS Blog

Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility
PTS Dot Plot Utility
PTS Cascade Chart Utility

 

 

Books at Amazon.com

 

Buy me a coffee

If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee.

  

Custom Chart Series Formatting

Introduction

Excel offers a wide variety of chart formats from its lists of built in choices: Nine marker styles; 56 colors to be applied to marker foregrounds and backgrounds; 56 colors and a handful of line thicknesses and styles for lines and borders; innumerable gradient effects and fill patterns.

Despite this wide variety of formatting choices, there are times when the same old same old won't cut it. Here are some examples of formatting choices that add character to your charts. Warning: a little funky formatting goes a lo-o-ong way! See the Introduction to the Charting Tutorial for a few reminders.

Apply Custom Markers to a Line, Scatter, or Bubble Chart

Stacking Pictures in Column and Bar Charts

Apply WordArt Labels to a Column or Bar Chart

 

 

Page copy protected against web site content infringement by Copyscape

 

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility PTS Dot Plot Utility PTS Cascade Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.

Peltier Technical Services, Inc.

Commercial Utilities | Custom Solutions | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile