Changing the Chart Data

[rudevincy]

Hi,

I have created a worksheet called DLR1 and I have a few comboboxs with a chart. I want that when the user selects a value from combo box 3 the chart data changes based on their selection.

In the combobox3_Change I have the code

ActiveWorkbook.Worksheets("DLR1").ChartObjects("Chart 3").Activate
ActiveChart.SeriesCollection(1).Values = _
"=='Rpt Temp_V5.xlsm'!BR_POST"
ActiveChart.SeriesCollection(2).Values = _
"=='Rpt Temp_V5.xlsm'!BR_Pre"
ActiveChart.SeriesCollection(2).XValues = _
"=='Rpt Temp_V5.xlsm'!BRChartDates"

But I keep getting an application defined error..... is there something I am missing.... please help!

 

[pgc01]

Hi

I've just read the post and the first thing I see is that you have 2 "=" signs where you should only have 1. Please check.

Ex.

ActiveChart.SeriesCollection(1).Values = _
        "[SIZE=4][FONT=arial][B][COLOR=#a52a2a]==[/COLOR][/B][/FONT][/SIZE]'Rpt Temp_V5.xlsm'!BR_POST"