Convert A Chart

Occasional Contributor

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 know.


5 Replies

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 table@mohsin91santono-_-1220 


Hi Gaurav
Thanks a lot for your insight


But Pivot is not solution for me.

I need it for some reason. :)


Hi Celia,

Could you please help in this post?

I have confidence that you can help.
Please Please Have A Look.....



I Solved It By Myself
Thanks @Celia_Alves  ;)

You showed a great way :D
I am forever grateful

Well done, @mohsin91santono-_-1220 ! I was also going to suggest tables and pivot tables as @Gaurav_Jalan did. I am glad that you were able to come up with a solution. That's the best way to learn Excel!


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies