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

Custom Chart Series Markers.

Tired of the same, lame choices for chart series markers? This page shows how to use any custom shape as markers in an Excel Line, Scatter, or Bubble chart.

Top of Page

Stacking Pictures in Column and Bar Charts

Build a Column or Bar Chart with Images.

Tired of using the same boring fill choices for columns and bars in your charts? This page shows how to use any custom shape to build an Excel column or bar chart.

Top of Page

My MVP Profile

Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog

Custom Chart Series Formatting

Introduction

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

Custom Chart Series Markers.

Stacking Pictures in Column and Bar Charts

Build a Column or Bar Chart with Images.

Apply WordArt Labels to a Column or Bar Chart

WordArt Labels for Custom Chart Series Fills.

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | PTS Blog