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 I 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 As 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 Pie 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!

android-10b-excel

Google officially announces 10 billion app downloads in Excel

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. [...]

Continue Reading

3D Setting in Excel Charts

Do it in Excel: Ring charts are better Pie charts

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801. Pie charts are simple to understand but rather limited because: 1. Can only show a single data series. 2. Can only show [...]

Continue Reading