Forum Discussion

saranp780's avatar
saranp780
Helper III
8 years ago

How to create a customize line chart?

f I have some data like this.

 

UsernameAdding YearCategory
A2016Account
B2016Account
C2016Account
D2016Account
E2016Account
F2016Account
G2016Account
H2016Account
I2016Account
J2016Account
K2018Account

 


I grabbed this data and create a Line chart and the result for the data was......

 

 

But I want the data display like this; 2016 = 10 and 2018 = 11

 

Now in my chart show 2016 = 10 and 2018 = 1 

 

following this image

 

How can I do this graph to show what I want? What I want are 2016 = 10 and 2018 = 11

 

Like in the picture I've created in another program(Following picture)

 

 

Anybody, please help me.

 

Thank you for all answer.

Need Help

4 Replies

  • Hardik's avatar
    Hardik
    Continued Contributor
    8 years ago

    Could you please provide more details of your requirement

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        8 years ago

        Hi saranp780,

         

        What does "10" and "11" mean? How to achieve the count value based on your posted table? Could you please provide more details about you logic to create the line chart?

         

        Regards,

        Jimmy Tao