OWC Chart: MultiLine Title

[Antonio Tirado]

Hi,

I need to the break the title of a Chart I'm generating
with ASP into multiple lines. Is this possible?. How can I
do it?.

Also is there a way to change the orientation of the
datalbels under a Bars Chart?. The labels I'm using Refer
to a Month-Year combination (first 3 letters of the month
plus 2 last digits of the year), but this is too long (I'm
plotting 3 years) so the labels are breaking up. Now in
excel you can change the orientation of the label but I
haven't found a way to do this on ASP.

Thanks in advance,

 

[Alvin Bruney [MVP]]

I've not yet found a way to break up the title into two lines. the last i
checked it didn't support html breaks or javascript new lines.

the datalabels have an orientation property which you can set. either use
the orientation enumeration or plain degrees only 90, 0, -90 are supported

 

[Guest]

Hi, Thank you for your answer.

I checked the documentation I have for the OWC but it
seems the orientation property is only available for the
Scaling?. Do you have an example on how to set the
orientation for the datalabels?

Thanks in advance,

-----Original Message-----
I've not yet found a way to break up the title into two lines. the last i
checked it didn't support html breaks or javascript new lines.

the datalabels have an orientation property which you can set. either use
the orientation enumeration or plain degrees only 90, 0, - 90 are supported

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

I need to the break the title of a Chart I'm generating
with ASP into multiple lines. Is this possible?. How can I
do it?.

Also is there a way to change the orientation of the
datalbels under a Bars Chart?. The labels I'm using Refer
to a Month-Year combination (first 3 letters of the month
plus 2 last digits of the year), but this is too long (I'm
plotting 3 years) so the labels are breaking up. Now in
excel you can change the orientation of the label but I
haven't found a way to do this on ASP.

Thanks in advance,

.

 

[Rex Moore]

Two line title:

MyChart.Title.Caption = "line 1 of title" & vbCrLf & "line 2 of title"

works for me...hope it works for you...

 

[Antonio Tirado]

Thank you for your answer.

What font family are you using?... It is displaying 2
squares when using Tahoma.

 

[Sascha Sertel]

This works fine for me on traditional ASP:
cht.title.caption = "Incomplete / " + vbNewLine + "Overdue Updates"

 

[Antonio Tirado]

It still shows 2 squares. Maybe I have to declare
something?.

 

[Sascha Sertel]

No, you don't really need to declare anything for that. What kind of chart
are you generating and how are you using it? The two squares come from
converting the linefeed and carriage return codes into actual symbols, which
sounds like a conversion issue between one string format and another or
something like that. Maybe you can provide some code from your chart and
show where you set and adjust your title.

Sascha

 

[Antonio Tirado]

This is the exact line I'm using:

cht.title.caption = "Test" + vbnewline + "test"

I'm generating a bars graphics using the OWC included in
office2k.

 

[Sascha Sertel]

It might be a cheap shot, but since the OWC included in Office2k is OWC10
and I am using OWC11, maybe that is one of the things they fixed when moving
on to the next version. Download version 11 from the Microsoft homepage and
try it with that, and let me know if it works or not!

Sascha

 

[Antonio Tirado]

Just did that and it works! . Thank you for support but
it seems that there's a new problem now.

I want to chart a lot of values but the control is only
displaying just a few of them. I want to chart rate for 3
years and its only showing 3 months per year and the
values are not correct for the months it chooses. I'm not
sure why this is happening but I think it might be trying
to interpolate the values?.

I'm trying to check the documentation to check what is
happening.

 

[Alvin Bruney [MVP]]

you need to turn off timescaling on the value axis