assign different chart line type under different condition with vba

Hi all,

As above, there are only two type of line and condition to consider here.

When condition 1 is met, the line is solid and condition 2, the line is dash.

Want to create a vba which link to excel cell when the condition are met, the line change itself.

There is Private Sub Worksheet_Change(ByVal Target As Range) in my file. No sure if this is the place to put the macro. Just let you know.

Here is the two macro I get from the record macro:

Please Login or Register  to view this content.

Appreciated any help given.

Hello DavidRoger

Can you tell what values that cell can have (ie. 1 or 2, Solid or Dash etc.)

Please Login or Register  to view this content.

Hi all,

I think I need to rephrase my message. Found something interesting after going through my vba.

Below is the code I use for .values, xvalues, line weight, name, and other:

Please Login or Register  to view this content.

Below code is the amended code I get from the above code. However this will not work because Range ("A100").value is for number not for text. Tried replacing with [A100] but not working too. What else can be use in the ??? below?

Please Login or Register  to view this content.

All help is appreciated and Happy New Year .

Originally Posted by Andy Pope

Please Login or Register  to view this content.

msoLineSysDash and msoLineSolid are VBA constants that have numeric values. The above checks for text match and then uses the constant.

Hi Andy,

This is what I do. I copy and paste the code into my vba. Enter cell A100 with msoLineSysDash or msoLineSolid. It's work.

I am prefer sure that not what you mean.

Other that than I tried

1) to change the line type manual, but nothing happen to A100.

2) And tried to insert A100 with number 1 - 100, also nothing happen.

Please confirm "The above checks for text match and then uses the constant".

Originally Posted by Andy Pope

Yes, just make sure the references to range and chart object are correct for your file.

Thanks.

Wish you good blessing in 2014.

When there are more than two conditions, in what way can the code be amended?

use select case or a 2nd Iif (but here it's twice the same condition and change the x in a valid expression)

Please Login or Register  to view this content.

Thanks both.

IIF and SELECT case is good.