Automatic update of charts and dashboard

datapig1

New Member
Joined
Feb 26, 2014
Messages
28
Hi all,

I'm relatively novice when it comes to Excel, however I do understand most concepts and by trial and error - and reading material - I've managed to create (again) relatively complex sheets when needed. Just to set expectations.

So, to my particular case. The main purpose is to have a dashboard with separate categories displayed e.g. different department within a company. Each category should have a corresponding custom figure with a color; green, orange and red based upon the result of that category. I know you can use traffic lights or even custom ones, but the design doesn't fit quite well so it needs to be a figure, most likely a rounded rectangle.

The tricky part is this. Every category should have its own worksheet with a chart that shows the result in a nice way, with the same rounded rectangle connected to the result of the chart. This is because the person looking at the dashboard can drilldown into the details of any particular category.

I've already created the templates and all the charts manually, so my next step would be to automate the process since this is gonna be updated on a monthly basis.

The whole process shall look like this:

Reports generated from SAP--->reports displayed in main worksheet (in tables or call it a database)--->Categories updated with charts with the correct rounded rectangle color in chart/beside chart; red,green,orange--->main dashboard same color in the rounded rectangle and as the category had.

Green >=100%
Orange >=90%, <100%
Red <90%

I don't know if this made any sense, but I'd like some suggestions on how to proceed. The link that's missing at the moment is the connection between the rounded rectangles and ultimately the dashboard.

Best,
DataPig1
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top