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>