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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies