Posts Tagged ‘Excel Charts’

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

Incorporating Analytical Extras into Your Charts

September 22nd, 2009

A former student of mine wrote me an email with this chart attached. He points out that most of his charts show data plus some additional analysis that typically isn’t plotted on the chart. In his example, he not only shows sales for each quarter, but also the % growth during the same quarter. No doubt he does this to avoid follow-on questions that will force him to talk to his manager.

  » Read more: Incorporating Analytical Extras into Your Charts

Suppressing Zeros in Chart Labels

September 14th, 2009

Susan writes me and asks if there is a way to suppress zeros in chart labels.

“I have a chart that’s dynamic in that I can choose a month that’s represented. For each month, and Sales Rep, there are up to 5 possible revenue streams, but not every Sales Rep has revenue for all revenue streams each month. Is there a way to remove the zero values from the labels in my chart?”

I want to drive traffic to this site, so I better answer her question.

  » Read more: Suppressing Zeros in Chart Labels