chartdata

Hy, I have the following code to put a chart on a userform with multipage: Function chart_v1()LoadSheets Dim MyChart As chart Dim ChartData, ChartData2 As Range Dim chartIndex As Integer Dim ChartName, ChartName2 As String Dim i As Long chartIndex = MultiPage1.Value Select Case chartIndex...

Good day. I have a userform with approximately 50 labels each containing a number which is the latest number in a column of numbers (i.e. I have 50 columns and say 365 rows). I have a code that calls another userform which has a graph when you click on any of the 50 labels (see code below)...

Good day, I have data in two columns - first is just date/time data, second is the variable in question. Normally I just set my ChartData (having declared variables earlier) in the following way. But a lot of the data in column two is sequentially identical. So you might get data in column B...