Both value and percentage on line chart

Occasional Visitor

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.
0 Replies