ExcelDashboardWidgets

Helping you create stunning dashboards in Microsoft Excel including dials, speedometers, thermometers, and much more...

Comparte tus hojas de cálculo salpicadero con otros usuarios aquí.

Moderator: DashboardWidgets

By Jenny
#148
Hi,

I'm trying to do something fancy, but it's way beyond me knowledge of excel

Layout:
Tab 1 - Data source (project info) from a query (freshable, thank goodness)
Tab 2 - Dashboard required. At the top, I've inserted a Format Control box which lists managers names. The object is to be able to click on the name eg. John Smith (within the Format Control box) and the project detail will appear against his/hers name.

Here's the tricky bit....

I have 4 static fields below the format box:

Inflight
Completed
Up & Coming
Cancelled

When someone selects a managers name from the Format Box....I want the data to appear (which is sourced from the data tab) to find it's static field and appear under either Inflight, cancelled etc.

I don't know if this can be done by a formula or VB.

Any solutions?
Thanks,
Jen

Download and try for free!