attach drop down box with chart

[vijaybhatt]

[TABLE="width: 356"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Quarter_1[/TD]
[TD]Quarter_2[/TD]
[TD]Quarter_3[/TD]
[TD]Quarter_4[/TD]
[/TR]
[TR]
[TD]Vendor_1[/TD]
[TD="align: right"]493[/TD]
[TD="align: right"]493[/TD]
[TD="align: right"]399[/TD]
[TD="align: right"]232[/TD]
[/TR]
[TR]
[TD]Vendor_2[/TD]
[TD="align: right"]388[/TD]
[TD="align: right"]408[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]281[/TD]
[/TR]
[TR]
[TD]Vendor_3[/TD]
[TD="align: right"]270[/TD]
[TD="align: right"]371[/TD]
[TD="align: right"]285[/TD]
[TD="align: right"]221[/TD]
[/TR]
[TR]
[TD]Vendor_4[/TD]
[TD="align: right"]386[/TD]
[TD="align: right"]287[/TD]
[TD="align: right"]371[/TD]
[TD="align: right"]152[/TD]
[/TR]
[TR]
[TD]Vendor_5[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]274[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]416[/TD]
[/TR]
[TR]
[TD]Vendor_6[/TD]
[TD="align: right"]454[/TD]
[TD="align: right"]238[/TD]
[TD="align: right"]465[/TD]
[TD="align: right"]313[/TD]
[/TR]
[TR]
[TD]Vendor_7[/TD]
[TD="align: right"]381[/TD]
[TD="align: right"]392[/TD]
[TD="align: right"]396[/TD]
[TD="align: right"]166[/TD]
[/TR]
[TR]
[TD]Vendor_8[/TD]
[TD="align: right"]345[/TD]
[TD="align: right"]232[/TD]
[TD="align: right"]354[/TD]
[TD="align: right"]223[/TD]
[/TR]
[TR]
[TD]Vendor_9[/TD]
[TD="align: right"]373[/TD]
[TD="align: right"]449[/TD]
[TD="align: right"]352[/TD]
[TD="align: right"]211
[/TD]
[/TR]
</tbody>[/TABLE]


THIS IS my data list i want to create chart with drop down list where if i select vendor_1 the it should show chart for vendor_1 with there values.

 

[Steve=True]

Hi vijaybhatt,

Here is a tutorial that describes your request.
how-to-create-dynamic-excel-dashboards-using-picklists


However, depending on your Excel version, you may want to consider a Pivot Chart. Here is a tutorial describing that technique:
how-to-insert-slicers-into-an-excel-pivot-table

how-to-create-a-dynamic-excel-pivot-table-dashboard-chart


Let me know if it helps.

Thanks

Steve=True

 

[vijaybhatt]

Hi Steve, I have gone through this tutorial I was stuck on it. but I found another way. using offset.
Thanks for help.

 

[Steve=True]

Glad you got it figured out. Thanks for the reply.