Peltier Technical Services, Inc.
 

Peltier Technical Services, Inc.
- Custom Excel Solutions

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS


PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart
  Box and Whisker
 

Excel Books

Books that I own and use while developing in Excel

 

Custom Chart Series Formatting


Excel Dashboards by ExcelUser.com - Instructional eBook and Ready-to-Use Workbooks.
 

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

 

 

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


Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. 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