Posts Tagged ‘Excel Charts’

Color Pie Chart Slices to Match their Source Cells

August 23rd, 2011

A few days ago, I posted a macro that will automatically set the series colors in a chart to match their source cell's colors.

.

After reading my post, Chris Umphlett got inspired to create a macro that automatically sets the data points in a chart to the same color as source cells.

.

Here's how it works.
» Read more: Color Pie Chart Slices to Match their Source Cells

Automatically Label First and Last Chart Points

August 16th, 2011

One of the best practices of dashboard building is to avoid overwhelming your customers with too much data at one time - especially in a chart, where they can lose sight of the primary message if focusing on inconsequential data. One of the common ways dashboard designers help focus the message of a chart is to limit the data labels to only the key points.

.

For example, I can make this chart easier to digest by removing all but the first and last data labels.

.

Once I have only two data labels, my eyes immediately take in the message of this chart (that we went from 11 to 53).
» Read more: Automatically Label First and Last Chart Points

Automatically Set Chart Series Colors to Match Source Cell Colors

August 10th, 2011

While working on a dashboarding project here, I accidently developed a charting macro that will automatically set the series colors in a chart to match their source cell's colors.

.

I'm not sure how useful this actually could be, but it's charming enough to share with my 12 fans.

.

Let's say I created this chart – and I want to apply specific coloring to each series without having to painstakingly change all the color options in each series.

» Read more: Automatically Set Chart Series Colors to Match Source Cell Colors

Quickly Change Chart Series Positions

August 8th, 2011

Well, the summer is over for many of us. I'm back to my regular blogging schedule (whatever that means).

.

For my first post back, I'd like to show you a trick I learned from charting guru, Jon Peltier.

.

Ever needed to switch the position of a chart series (color and all)?

In this example, I want to show the series in red first. I've already created my chart, so I just want an easy way to switch the positions of the columns.
» Read more: Quickly Change Chart Series Positions

Stacked Thermometer Chart

January 13th, 2011

Wendi wrote me an email the other day asking:

"Datapig you are best Excel persons in the world ... how to make thermometer chart with a stacked column?"

My first international lady fan!  Could it be true?  Could I be offically too sexy for just the Continental U.S.?

While I ponder that thought, here is Wendi's answer.…

. » Read more: Stacked Thermometer Chart

Excel Hero and Animated Charts

October 22nd, 2010

Daniel Ferry is the purveyor of one of the more interesting Excel Blogs out there (ExcelHero.com). His blog has the curious distinction of being the only one with an unexplicable rooster on the banner:
Excelhero

If you've never visted, you must. Daniel has a knack for passing on advanced Excel techniques through
» Read more: Excel Hero and Animated Charts

Auto Adjust Chart Label Positions

September 22nd, 2010

I got a call from one of the friends in my "network" asking me there is any way to auto-adjust chart label positions based on values.

Apparently, he's not too happy about having to pre-set his label positions (for example data labels below the data point). Mainly because he creates dynamic charts that his users can interactively change. When his chart changes, the labels sometimes get muddled and land in places that aren't really ideal – like the pictures here
» Read more: Auto Adjust Chart Label Positions

Selecting Hard to Reach Chart Elements

September 6th, 2010

Anyone who has worked with Excel charts extensively has inevitably encountered the "hard to reach" scenario. That is, the formatting and configuration of your chart makes certain chart elements seemingly unreachable. Today, I'll show you a forehead-slapping trick that will both give you relief, and make you feel stupid at the same time.

  » Read more: Selecting Hard to Reach Chart Elements

The Trouble with Chart Data Tables

April 26th, 2010

Chart Data Tables are actually very useful for showing plotted values without inundating your audience with a gaggle of chart labels. I use them all the time.

 

My problem with them is that their uglier than a bag of lips. For all their usefulness, they sure do emit that "1997" feel.  Luckily, Excel gives you a few options that help dial back the "ugly" on your chart Data Tables.

  » Read more: The Trouble with Chart Data Tables

Sometimes Two Charts are Better than One

April 19th, 2010

Last week, I was caught in a vortex of executive reviews, publishing deadlines, and other miscellaneous family stuff. (Note the placement and miscellaneous status given to "family stuff". This is why I'm going to die alone.)

In any case, during the executive review prep, we had a bit of a debate on how a certain set of data should be represented.

The basic idea is that we have a FY 2010 goal. Each month, we add values to get us to that goal. The question is how to show this on a chart.

» Read more: Sometimes Two Charts are Better than One