vertical 90 degrees chart OWC (please)

[liliana]

Could you please tell me if......???

I'am creating charts in ASP using Microsoft Office Web
Components, I need x-axis titles be rotated (vertical or
90 degrees)

set RS2 = Server.CreateObject("ADODB.Recordset")
RS2.CursorType = adOpenStatic
RS2.cursorlocation = adUseClient
RS2.Open sSQL,Conn

set oChart = Server.CreateObject("OWC.Chart")
Set c = oChart.Constants
set objChart = oChart.Charts.Add()
set oChart.DataSource = RS2

objChart.Type=c.chChartTypeLineMarkers


objChart.Legend.Font.Name="Tahoma"
objChart.Legend.Font.Size=7

objChart.SetData c.chDimSeriesNames,0,"Productos"

for each objSeries in objChart.SeriesCollection
objSeries.SetData c.chDimCategories,0,"Mes"
objSeries.SetData c.chDimValues, 0, "Precio"
next

for each axis in objChart.Axes
axis.HasTitle = True
if axis.Type = c.chCategoryAxis then

'axis.Orientation=90
'axis.DataLabelsCollection.Orientation = 90
'axis.Orientation = Upward
'axis.c.chAxisPositionCategory.CategoryLabels.Alig
nment.Rotation = 90
'axis.Orientation = c.chLabelOrientationDownward
'axis.Orientation = 90
'axis.orientation=c.chLabelOrientationUpward

the line them in green they mark error, please help me.


axis.Title.Caption = "Año/Mes"
set objFont=Axis.Title.Font
objFont.Name="Tahoma"
objFont.Size=10
objFont.Bold=True
else
axis.Title.Caption = "Precio"
set objFont=Axis.Title.Font
objFont.Name="Tahoma"
objFont.Size=10
objFont.Bold=True
end if
next

oChart.ExportPicture server.MapPath
("exportprices.gif"), "gif", 900, 500
response.Write "<img src='exportprices.gif' > "

%>



Thanks for any
help.

 

[Thao Moua [ms]]

OWC9 does not support vertical text for axis. You must use OWC10 or OWC11.

----------------------------------------------------------------------
Thao Moua
OWC Chartspace Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[Lilia]

Yes, but I'm using Office XP, and
set oChart = Server.CreateObject("OWC.Chart") and
version Microsoft Office XP web Components 10.0.6619.0 and
I'have msowc.dll

why marks error in:
'axis.Orientation = c.chLabelOrientationDownward

Tipo de error:
Error de Microsoft VBScript en tiempo de ejecución (0x800A01B6)
El objeto no acepta esta propiedad o método: 'c.chLabelOrientationDownward'

thanks,