AxMSChart rowlabel

Hi,

Current code:
AxMSChart1.RowLabel = "aaa" & ", " & "bbb"

How to write the code, so it'll appear as

aaa
bbb

instead of aaa, bbb?

You'd have to split the string into values, then use this, to strip out the center value

Code:

---

Dim a as string = "aaa" : Dim b as string = "a, " : Dim c as string = "bbb"
String.Format({0}{1}{2}", a, Environment.NewLine, c)

---

Quote:

---

Originally Posted by dglienna

You'd have to split the string into values, then use this, to strip out the center value

Code:

---

Dim a as string = "aaa" : Dim b as string = "a, " : Dim c as string = "bbb"
String.Format({0}{1}{2}", a, Environment.NewLine, c)

---

---

You mean AxMSChart1.RowLabel = String.Format("{0}{1}{2}", a, Environment.NewLine, c) ?

i still get "aaabbb" instead of

aaa
bbb.

Try this:

Code:

---

AxMSChart1.RowLabel = String.Format("{0}{1}", a & Environment.NewLine, c) ?

---

or

Code:

---

AxMSChart1.RowLabel = String.Format("{0}{1}", a & vbCrLf, c) ?

---

or use Environment.NewLine as b, and print a,b,c

Is your label set to MultiLine? That's probably the answer, now that I think of it

Quote:

---

Originally Posted by dglienna

Try this:

Code:

---

AxMSChart1.RowLabel = String.Format("{0}{1}", a & Environment.NewLine, c) ?

---

or

Code:

---

AxMSChart1.RowLabel = String.Format("{0}{1}", a & vbCrLf, c) ?

---

or use Environment.NewLine as b, and print a,b,c

Is your label set to MultiLine? That's probably the answer, now that I think of it

---

Still cannot haha.. The AxMSChart don't have the multiline function. =x

Set the HEIGHT to double and try