Forum Discussion

mohsin91santono-_-1220's avatar
mohsin91santono-_-1220
Brass Contributor
Mar 20, 2019
Solved

Convert A Chart

Hi There.   I am new for advance excel techniques.   Could you please help to provide solution? I have attached an image which is self explanatory.   If you have any question, please let me kn...
excel
Gaurav_Jalan's avatar
Gaurav_Jalan
Copper Contributor
Mar 20, 2019

Use pivot table instead using any formula , still you want to use formula define a value on which base you want to see that report like date , model number or any other head then u can use formula for making such reports, but i suggest to use pivot tablemohsin91santono-_-1220 

  • mohsin91santono-_-1220's avatar
    mohsin91santono-_-1220
    Brass Contributor
    Mar 20, 2019

    Gaurav_Jalan 

    Hi Gaurav
    Thanks a lot for your insight

     

    But Pivot is not solution for me.

    I need it for some reason. :)

Resources