(Solved) – Connecting lines in MS ACCESS chart


I have chart that looks like this:
enter image description here

And I want the user to have an option to change it to something like this:enter image description here

I am using this code to build it and it works perfectly fine:

 Me.ChartResult.ChartType = xlColumnClustered

However, if I use this line to get things back

 Me.ChartResult.ChartType = xlLineMarkers

I receive this result with lines connecting each point which is something I don’t want to have.
enter image description here

I want the chart to be the same as the first one. But If i use this code:

With Me.ChartResult
 .ChartType = xlXYScatter
 .HasHiLoLines = True
End With

I receive Run-time error ‘438’: Object doesn’t support this property or method

I can use only the .ChartType = xlXYScatter, but then I don’t have these HiLoLines which i really need to have.

Leave a Reply

Your email address will not be published. Required fields are marked *