Hi
I have a graph that has product & product sales, the product sales have data labels with the numeric value on top, I'd like to add percentage variance underneath this but not sure how, I've seen a few threads that say you add the percentage variance data series, overlay it to 100%.. but then when I add data labels it tries to conform to the product sales axis and doesn't appear under the first data label.
Here is a small data sample to work with, just unsure of the steps
If possible, I'd like to see it formatted like this, example for AAAA would be 9, line break, (-67%).. BBBB would be 82, line break, (64%)
<colgroup><col span="3"></colgroup><tbody>
</tbody>
I have a graph that has product & product sales, the product sales have data labels with the numeric value on top, I'd like to add percentage variance underneath this but not sure how, I've seen a few threads that say you add the percentage variance data series, overlay it to 100%.. but then when I add data labels it tries to conform to the product sales axis and doesn't appear under the first data label.
Here is a small data sample to work with, just unsure of the steps
If possible, I'd like to see it formatted like this, example for AAAA would be 9, line break, (-67%).. BBBB would be 82, line break, (64%)
| Sales | ||
| Product | TY | vs. LY % |
| AAAA | 9 | -67% |
| BBBB | 82 | 64% |
| CCCC | 24 | -74% |
| DDDD | 61 | -29% |
| EEEE | 61 | 144% |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
