Nikitha Niranjana
New Member
- Joined
- Feb 9, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
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 when I source data. Any assistance on the same would be really helpful.
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 when I source data. Any assistance on the same would be really helpful.