I would like to Create A chart i Excel with Drop Down list appears on the
Chart to be able to select the data to be plotted on the chart.

You can't use a drop down box but you can use an Input Box. This macro will
work if you already have a chart on the worksheet. Change Chart Name "Chart
1" and sheet name as required.

Sub GetChart()
'
Set ChartArea = Application.InputBox( _
prompt:="Select Chart Range", Type:=8)

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.SetSourceData _
Source:=Sheets("Sheet2").Range(ChartArea.Address)
End Sub


"Khaled" wrote:

I would like to Create A chart i Excel with Drop Down list appears on the
Chart to be able to select the data to be plotted on the chart.

HI,

You can use the pivot table which can do the needfull in your case. It gives
you the drop down arrow to select and also the chart
Menu bar DataPivot table
--
Thanks
Suleman Peerzade


"Khaled" wrote:

I would like to Create A chart i Excel with Drop Down list appears on the
Chart to be able to select the data to be plotted on the chart.