Dietmar P. came up with a nice cell based chart at (external link!) Controller Akademie.
I applied some changes and enhancements like introducing auto-scaling and adding two parameters:
A number format to allow for a general format change if necessary
A Boolean parameter to control whether to switch the green and red colouring of the chart. If you hire a contractor then you might like to show staying below the budget with a green colour, but if you like to present sales figures then it might be the other way round
Formula in H9:
In sheet Param all parameters have been collected:
These parameters have been named as shown in the Name Manager window:
A possible switch between colours green and red is implemented via a conditional format, for example in column I:
Please read my Disclaimer.
Cell_based_charts.xlsx [20 KB Excel file, open and use at your own risk]