Hi all,
I have a dynamic dashboard mini chart built that populates from a drop down box used to select some data that's reported in months. The data set has different UOM - some are in % some are numbers and others in minutes. Example below:
<tbody>
</tbody>
The chart I have built will populate the data (I can not use a dynamic table as there are formulas built into the data) however I have to manually to change the number format for the chart labels to show the label correctly i.e. going from a number to a %
I tried to get around this by making a Custom Format Code (first ever attempt at this) in the Format Data Labels but I cannot seem to get it right, as there are "0's" in the data and there are minutes.
[<1.25] 0.0%;[>1.2] #,###
I don't mind if I have to use VBA to get this working but would prefer an easier solution.
Hope this is clear enough to understand! thanks!
I have a dynamic dashboard mini chart built that populates from a drop down box used to select some data that's reported in months. The data set has different UOM - some are in % some are numbers and others in minutes. Example below:
Jan-17 | Feb-17 | Mar-17 | |
Eggs | 17% | 19% | 20% |
Banana | 200 | 0 | 250 |
Fruit | 0:8:1 | 0:16:01 | 0:18:00 |
<tbody>
</tbody>
The chart I have built will populate the data (I can not use a dynamic table as there are formulas built into the data) however I have to manually to change the number format for the chart labels to show the label correctly i.e. going from a number to a %
I tried to get around this by making a Custom Format Code (first ever attempt at this) in the Format Data Labels but I cannot seem to get it right, as there are "0's" in the data and there are minutes.
[<1.25] 0.0%;[>1.2] #,###
I don't mind if I have to use VBA to get this working but would prefer an easier solution.
Hope this is clear enough to understand! thanks!