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%)
[TABLE="width: 192"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 3, align: center"]Sales[/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]TY[/TD]
[TD]vs. LY %[/TD]
[/TR]
[TR]
[TD]AAAA[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]-67%[/TD]
[/TR]
[TR]
[TD]BBBB[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]64%[/TD]
[/TR]
[TR]
[TD]CCCC[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]-74%[/TD]
[/TR]
[TR]
[TD]DDDD[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]-29%[/TD]
[/TR]
[TR]
[TD]EEEE[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]144%[/TD]
[/TR]
</tbody>[/TABLE]
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%)
[TABLE="width: 192"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 3, align: center"]Sales[/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]TY[/TD]
[TD]vs. LY %[/TD]
[/TR]
[TR]
[TD]AAAA[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]-67%[/TD]
[/TR]
[TR]
[TD]BBBB[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]64%[/TD]
[/TR]
[TR]
[TD]CCCC[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]-74%[/TD]
[/TR]
[TR]
[TD]DDDD[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]-29%[/TD]
[/TR]
[TR]
[TD]EEEE[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]144%[/TD]
[/TR]
</tbody>[/TABLE]