Forum Discussion

Nikitha_Niranjana's avatar
Nikitha_Niranjana
Copper Contributor
Feb 09, 2021

Both value and percentage on line chart

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.
No RepliesBe the first to reply

Resources