How to create chart in Pivots

[Ratan Bhushan]

Hi Team

I have some data and I have prepared few pivots. Now I want chart in front of each pivots but I am failing. I have uploaded the file, Please to help.
And please advise if it is possible that if we can give user to choice a table name and only that chart appears.

 

[Deepa9]

Hi,

Hope this works. find the attached file.

Regards

 

[Ratan Bhushan]

Hi,

Hope this works. find the attached file.

Regards

Deepa you are superlike

But in the charts, for weeks, the bar of the same week are one on another, is it possible that we can separate them and then showing the Q1 bars then Q2 bars and so on, because I have to make this file weekly

 

[Ajesh]

See if this is what you want. All that was needed in @Deepa9's solution was to change the Chart Type from 'Stacked Column' to 'Clustered Column'.

Thanks