cyrilbrd
Well-known Member
- Joined
- Feb 2, 2012
- Messages
- 4,113
- Office Version
- 365
- Platform
- Windows
- Mobile
given table as follows:
In Powerview, Column Chart set as follows:
∑ VALUES is ∑Average of %
AXIS is farm
LEGEND is #
Now percentages are seen as 0.xx instead of xx%
Any idea how to format Data Labels to reflect values as percentage?
| Excel 2013 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | farm | # | month | Diesel | Gasoline | Jet A1 | total | year | % | ||
| 2 | global | Operation | ######## | 0 | 0 | 0 | 30554 | 2014 | 44.8% | ||
| 3 | global | Genset | ######## | 0 | 0 | 0 | 14968.45 | 2014 | 22.0% | ||
| 4 | global | Support | ######## | 0 | 0 | 0 | 21207.5 | 2014 | 31.1% | ||
| 5 | global | Delivery | ######## | 0 | 0 | 0 | 1434.5 | 2014 | 2.1% | ||
| 6 | global | Operation | ######## | 0 | 0 | 0 | 30209.5 | 2014 | 44.9% | ||
| 7 | global | Genset | ######## | 0 | 0 | 0 | 14792.19 | 2014 | 22.0% | ||
| 8 | global | Support | ######## | 0 | 0 | 0 | 19480 | 2014 | 29.0% | ||
| 9 | global | Delivery | ######## | 0 | 0 | 0 | 2746 | 2014 | 4.1% | ||
DB | |||||||||||
In Powerview, Column Chart set as follows:
∑ VALUES is ∑Average of %
AXIS is farm
LEGEND is #
Now percentages are seen as 0.xx instead of xx%
Any idea how to format Data Labels to reflect values as percentage?
Last edited:
