• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Select the month & display the weeks in charts - Please help

S

SG

Member
Hi Experts,

I need your help in presenting the week wise time used in an account. What i need is to prepare a chart in which when i select month & name,
the no. of weeks & its values in that particular month would be the source data of chart.

For e.g, if i select 6 as month (which is june) & name as "a", the chart would display the time used by "a" in activites of weeks 23,24,25 & 26.

one more chart with if i select 6 as month , name as "a" , chart would display time used by "a" account wise in weeks 23,24,25,26.

Please help me with the solution. I have attached the data for you reference.

Thanks in advance.
 

Attachments

  • utilization.xlsx
    11.5 KB · Views: 4
Hi Narayan,

Thanks for the solution. Can you please tell me more ways to represent such analysis.
 
You must log in or register to reply here.
Back
Top