Creating a dashboard in exel

Question

Hi guys,

I am looking at creating a dashboard in excel using several key performance indicators to plot a graph, the data would just be collected from another sheet in excel. I understand that you can do this in conjunction with macros but my experience with macros is limited although I am willing to learn.

Any help would be great!

Thank you!

Answer 1

You might start without macros and learn VBA only if you need a feature you really want. Some links may help you get started:

• Excel charts, already mentioned by Benjol
• Yet another math programming consultant
• Juice Analytics

Answer 2

Darren,

Plotting a graph or any data for certain section (which is DASHBOARD for you) from an existing sheet in a single EXCEL WorkBook (File) is easy. You jut need to select graph wizard and point to the cell ranges in that sheet.

You can also plot this from another sheet as long as know the path. This can be controlled by writting some code to make it more dynamic.