I want to make custom looking chart through Pivot & Slicer

[shaikhrulez]

Hello experts,

Please refer attached file. I got data of two different medium viz. DCS & GPS for the period Nov-2017 to Jan-2019 of various Branches in my Org and I would like to summarize the data through pivot table and Pivot Chart by using Slicer.

Furthermore, despite several attempt I am unable to get below look of Chart through Pivot Table & Pivot Charts.



It would be really helpful, if you guys can spare some time and provide me some ideas to display the given data through Pivot Table & interactive charts.

Thanks.

 

[shaikhrulez]

anyone ??? @Khalid NGO

 

[shaikhrulez]

Is this forum no longer helpful?? No response to a simple query. Waiting for last 2 days.

@Hui @Khalid NGO @r1c1 @NARAYANK991 @Luke M @Chihiro

 

[Khalid NGO]

Is this forum no longer helpful??

Hi Waqar,

Forum is always been helpful, several questions have been answered with no time.

Some members (including me) available in weekdays only. I am not much familiar with Pivot Charts, hope someone will respond.

Your patience is requested.

 

[Luke M]

As Khalid alluded to, be aware of time differences. For my time zone, you posted your question after business hours on a Friday, and I don't check back in until Monday. Here's a start to your file. Chart created as pictured, and slicers made.

 

[shaikhrulez]

As Khalid alluded to, be aware of time differences. For my time zone, you posted your question after business hours on a Friday, and I don't check back in until Monday. Here's a start to your file. Chart created as pictured, and slicers made.

Thanks @Luke M and sorry for the exigency I created. I didn't know that members of this forum are busy on weekends.