Bapek3
08-27-2018, 05:58 AM
Hi
Please service where i am making a mistake
I need to select the data for the chart
I do it this but it does not work
Sub data_chart
Dim chart as long
chart = range("a5").end(xlToRight).offset(0, 1).select
ActiveSheet.chartObject("chart 1").activate
Active.Chart.ChartArea.select
Activated.Chart.SetSourceData Source:=Range("a1" & ":" & "chart")
End sub
Thank you for your advice
Please service where i am making a mistake
I need to select the data for the chart
I do it this but it does not work
Sub data_chart
Dim chart as long
chart = range("a5").end(xlToRight).offset(0, 1).select
ActiveSheet.chartObject("chart 1").activate
Active.Chart.ChartArea.select
Activated.Chart.SetSourceData Source:=Range("a1" & ":" & "chart")
End sub
Thank you for your advice