All articles with 'excel drawing' Tag

Dynamic Dashboard in Excel – Pulling it all together [Part 4 of 4]

Published on May 26, 2010 in Charts and Graphs, VBA Macros
Dynamic Dashboard in Excel – Pulling it all together [Part 4 of 4]

In the last installment of our dynamic dashboard tutorial, we will take all that we have learned in first 3 parts and combine that to create a final dashboard. We are going to use concepts like table of contents, macros and data validation to help us get ahead. You can find the entire macro and downloadable workbook inside the post. Read on…

Continue »

Making a Dynamic Dashboard in Excel [Part 3 of 4]

Published on Apr 22, 2010 in Charts and Graphs, VBA Macros
Making a Dynamic Dashboard in Excel [Part 3 of 4]

In this post we are going to look at a simple example of the VBA behind the Dynamic Dashboard. Essentially we will learn to write macros for doing this. Read the rest of this post to find code samples and downloadable files to play with.

Continue »

Use Shapes and Images to make Prettier Charts [Dashboard Tricks]

Published on Dec 3, 2009 in Charts and Graphs
Use Shapes and Images to make Prettier Charts [Dashboard Tricks]

One of the annoyances of charts is that they all look like boxes (except for pie charts, they just look wrong). Boxes might be ok when you are making 1 or 2 charts. But a whole dashboard of boxes can look little rigid. So how can we make the charts peppy without loosing any effect? Like these charts below:

Very simple, we use drawing shapes in MS Excel to draw whatever we want and overlay the chart on top.

Continue »

Excel Links of the Week – Do you want to run 10k with me edition

Published on Nov 17, 2008 in Learn Excel, personal

It has been almost 9 months since I crossed the 5k running mark for the first time in my life. Running is one of the most enjoyable things I do. I have been running between 5 and 7 kilometers ever since. I wanted to run 10 kilometers and finally I am confident of doing it. […]

Continue »