Making Beautiful Excel Charts is Simple

By |December 6th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

Have you ever told yourself that creating great looking Excel charts is hard? Well it's not. You only need to understand the only reason we create charts is to aid comprehension of a trend. Once you understand this, you can [...]

Excel Line Charts with Elegant Dates

By |August 29th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I came across this stock chart in the Kuala Lumpur's edition of the Business Times while I was in Malaysia. The chart has an elegant treatment of dates. I have seen this sort of designs in many magazines and wanted [...]

BP Oil Spill shown in a Microsoft Excel Chart

By |July 12th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

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 [...]

Lollipop approach to clarify Microsoft Excel line charts

By |July 5th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog|Tags: , |

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 [...]

Singapore population infographic in Microsoft Excel

By |May 23rd, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

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 [...]

PowerUp Workshop: Making Beautiful Excel Charts

By |January 4th, 2010|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

What if you could turn a drabby Excel chart: into something like these? For many Excel users, there is a need to produce clear, concise and even attractive charts in Excel without using expensive software. What is lacking are the [...]

8 Microsoft Excel Chart Formatting Tips

By |October 5th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: , |

I will demonstrate the following chart formatting tips starting from Microsoft Excel 2003. 1. Remove plot area colours and borders. 2. Remove any vertical grid-lines. 3. Change horizontal grid-line color from black to a very light shade of gray. 4. [...]

A crappy chart from the Straits Times. GIC looking to Asia, emerging markets

By |September 29th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related|Tags: , |

I'm going to take a potshot at the Straits Times on a chart I saw in the Money Section. The chart was trying to compare GIC's (Government of Singapore Investment Corporation) current asset mix to last year's asset mix. It gave [...]

A New York Times Chart in Excel

By |September 23rd, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Training Courses|Tags: |

I was surfing the web and came across this chart from the New York Times. My attention was totally captivated by this intricate chart. It says that healthy food are getting more expensive while junk foods are getting cheaper! What's [...]

Magazine quality charts in Excel 2003

By |September 16th, 2009|Categories: Beautiful Charts in Excel, Excel & PowerPoint Blog, Excel Dashboard Related, Excel Training Courses|Tags: , |

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 [...]