Visualizing values from various charts in one sheet object
can somebody help me, please.
In my management cockpit I want to show relevant results (values) from 8 different charts in one sheet object as an overview.
Maybe the following example can help you to understand my intention:
A first linechart shows the development of the KPI "ROI" from 2005 till 2012
A second linechart shows the development of the KPI "ROCE" from 2005 till 2012
A third ...
Now, what I want is to show the current value of "ROI" (current value = 55,47%) and "ROCE" (current value = 51,11%) from 2012 in one sheet object together. In addition it has to flexible no static string visualisation of the current values. That has to meant that a change to the values of the charts has to implised changes to the values of the sheet objects, too.