Hello,
I am trying to get both values and percentage on a line chart in excel.
My data is as such,
Month. Series1. Series 2
Jan. 521. 395
Feb. 545. 321
I am trying to represent it as 521 57% and 395 43% on the chart.
I used the formula to get this format ( 521 57%)
But while trying to represent it, both the series are taking same values I shown in attached picture below. Any assistance on the same would be really helpful.