SOLVED
Home

Convert A Chart

mohsin91santono-_-1220
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.

TIA

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 

@Gaurav_Jalan 

Hi Gaurav
Thanks a lot for your insight

 

But Pivot is not solution for me.

I need it for some reason. :)

@Celia_Alves 

Hi Celia,

Could you please help in this post?

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

Solution

@mohsin91santono-_-1220 

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