Magazine quality charts in Excel 2003. How AEternus do it.

Posted by CH Leong on Wednesday, September 16, 2009 · Leave a Comment 

I’d like to show you how we run our Excel Charting courses in Aeternus. I promise that after attending our Excel Charting course, your Excel charting skills will definately go up by several notches. As an example, I plucked out a pretty line chart from the Economist Magazine August 2009 issue.

Line chart from Economist Aug 2009 issue

Line chart from Economist Aug 2009 issue

Imagine you can create such charts directly in Excel!

The benefits:

  • Refreshing way to present charts.
  • You do not need expensive charting software.
  • Explain your charts to management with your commentary.
  • Carry this skill everywhere you go.

The process:

Step 1: I started with data in a typical worksheet.

Sample figures in a Excel 2003 worksheet

Sample figures in a Excel 2003 worksheet

Step 2: Using the above figures, I insert a typical Excel line chart.

Step 3: We will coach you through detail steps to produce this Excel chart. Clearly, the results speak for themselves.

Once this chart is created, you simply need to update those numbers and new charts are redrawn. You can also update your expert comments right inside the chart!

New series of Excel 2003 charts are easily created

New series of Excel 2003 charts are easily created

Step 4: We don’t stop here. AEternus will build upon your newly acquired charting skills to create entire management dashboards.

You can view more details about our Dashboarding Course here.

No related posts.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


excel

You really should know VBA Programming

Jul 29, 2010 | 2 Comments

If you are someone who uses Microsoft Excel to generate statistics-based business reports, create forecasts or do alot of routine Excel manipulations, this is why you need to know Visual Basic for Applications (VBA). It makes you work faster. A lot more faster. Here are some more reasons: 1. All versions of Excel support the [...]

Continue Reading

singapore population statistic inforgraphic in Microsoft Excel

Singapore population infographic in Microsoft Excel

May 23, 2010 | Discuss

This is an info-graphic I created in Microsoft Excel. It shows the population composition of Singapore in 2009. The world map and the stick-man was from the standard web-ding font. The only exception was the Singapore flag which I copied from Wikipedia. Nothing fancy was used. Just pure Excel 2007 features, no more no less. [...]

Continue Reading

If I can blame you, I can trust you...??

Why IT folks hate Microsoft Excel

May 22, 2010 | 2 Comments

Yes they do. Which is why you hardly get any good support when you have a problem with it. Try opening a support ticket when you hit a snag with Excel. It won’t see the light of day. So why do IT folks hate Microsoft Excel? 1. It’s tough for IT folks to distribute and [...]

Continue Reading

This chart applies the "Lollipop Approach". Dates are easily associated with the stock price and events of the BP oil spill.

BP Oil Spill shown in a Microsoft Excel Chart

Jul 12, 2010 | Discuss

On 20 April 2010, a BP oil well exploded in the Gulf of Mexico, causing the largest offshore spill in U.S. history. This Microsoft Excel line chart illustrates some key events 2 months after the explosion and BP’s stock price using a common Date horizontal axis. The resulting chart is rich in information yet it’s [...]

Continue Reading

Error bars from each data point associates the relevant axis labels clearly

Lollipop approach to clarify Microsoft Excel line charts

Jul 05, 2010 | Discuss

Traditional Microsoft Excel line charts have a common problem. It is hard to visually associate the data points with the horizontal axis. The traditional axis line is no help at all. We can get around this problem by using data markers. Certainly an improvement, but we still need to mentally drop imaginary lines between the [...]

Continue Reading