PivotChart and different size axis

[Tobias Olbort]

Hello,

in a PivotChart i've different line charts. Some lines show values in
°C (varying from 0 to 140), some lines show values in % (0.0 to 0.6).
To display that, i want to use two y-axis with the appropriate value
ranges and units.

It is possible to add a second y-axis to the chart. But how can i
assign a chart-line to a specific y-axis? With MSGraph8 it was
possible to select the y-axis in the properties.

Furthermore i'm looking for better descriptions than from MS to
PivotChart - especially the API (is there any book?).

Thanks for any help.

Tobias

 

[Thao Moua [ms]]

First you should create your line chart using the same
value axis. Next ungroup the line graph you want from
the line graph collection.

'this will ungroup series 2 and give it a new scale
CS.Charts(0).seriescollection(x).ungroup TRUE

Thao Moua
OWC Webchart Support

 

[Wei-Dong Xu [MSFT]]

Hi Thao,

PivotTable Component Object Model may provide some assistance for you to
use the pivotTable component better. Please go to:
http://msdn.microsoft.com/library/en-us/modcore/html/pivlist.gif
http://msdn.microsoft.com/library/en-us/modcore/html/degrfmicrosoftoffice200
2pivottablecomponentobjectmodelpage2.asp?frame=true

Furthermore, you can obtain the Microsoft Office XP Web Component Toolpack
from Microsoft.com which contains samples and walkthroughs of the new
features of the Office XP Web Components. There is many pivotsTable
examples there which will help you a lot. Please go to:
http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-
A13C-50E56F101720&displaylang=en

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.