SOLVED

Convert A Chart

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

best response confirmed by mohsin91santono-_-1220 (Brass Contributor)
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!

 

1 best response

Accepted Solutions
best response confirmed by mohsin91santono-_-1220 (Brass Contributor)
Solution

@mohsin91santono-_-1220 

I Solved It By Myself
Thanks @Celia_Alves  ;)

You showed a great way :D
I am forever grateful

View solution in original post