Graphs

[Supriya]

I have 15 graphs on Daily, weekly & monthly data for 5 different categories.

pl help how to display the graph categories wise & Daily, weekly & monthly.

Means if i select the category_1 & then choose the daily the sheet display only daily graph

....


Regards,

Supriya

 

[kaushik03]

Hi Supriya,


There could be many ways to do this.


However, would request you to please upload a sample workbook here so that, person who gonna help you do not need to create any dummy data to work on this.


http://chandoo.org/forums/topic/posting-a-sample-workbook


Looking forward to your co-operation.


Kaushik

 

[NARAYANK991]

Hi Supriya ,


Do you think you can go through this and use the technique explained there ?


http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/


Narayan

 

[Supriya]

hi kaushik,


Please find the below file link


https://www.box.com/s/ea0uxjn2ko6q8xrebjuh


this is sample data

if i select Category A then excel should display 3 option Daily, Weeekly & monthly according to that after selecting one of the option (Daily, Weeekly & monthly) data graphs will be display. same for all category, repeat the above

procedure.


Thanx,

Supriya.

 

[sreekhosh]

Hi Supriya,


Please see the uploaded file below and confirm is this useful.


https://www.dropbox.com/s/skjnd3wntzuso8r/Sample.xlsx


Thanks


Sreekhosh

 

[Supriya]

Hi Sreekhosh,


sorry for late reply.

Thanx a ton.

this looks very nice.


Regards,

Supriya A.