Magazine quality charts in Excel 2003

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 magazine quality 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.

To learn more about how to create beautiful charts like these in Excel, check out this workshop: Beautiful Excel Charts

Learn more about Creating Dashboards in Excel.

Related posts:

  1. A magazine quality chart in Excel ShareI know the idea of creating beautiful charts in Excel seems unfamiliar, but I assure you Excel is a very capable platform to do so....
  2. Top 5 mistakes of Excel Charts ShareAs you know, an Excel chart can make complex relationships much clearer than words and numbers can. But more often than not, most of us...
  3. Do it in Excel: Ring charts are better Pie charts SharePie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented...

Comments

One Response to “Magazine quality charts in Excel 2003”
  1. NepliepeAwake says:

    Hello. Very interesting site and you lead a very interesting discussion. There is a nice atmosphere here and I’m sure I will often read your posts.
    From time to time I will also try to write something interesting.

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!

trust

How to trust an Excel VBA application?

Share A trust worthy person should be: 1. Honest & true. 2. The person is honest and true in many different situations. 3.The person is honest and true over a long period of time. Trusting an Excel VBA application is like trusting a person. When you trust a person, you have an expectation that this [...]

Continue Reading

Just as I was about to get used to Excel 2010. Now the game changed again!

Office 15, Word 15, Excel 15 & PowerPoint 15 screenshots.

ShareIt didn’t seem too long ago that Microsoft released Office 2010 (Office 14) upon us. Continuing the Windows 8 momentum we soon will hear about Office version 15! Here’s what going to happen. According to a Bloomberg report, Microsoft plans to finish up all work on Windows 8 by summer 2012 and release the new [...]

Continue Reading

Connect with us on Social Media

Twitter
Discussion forum, directions to office, new ideas, discounts and offers.

Any questions?

  1. (valid email required)
  2. (required)