OWC11 - pivotcharts - CrossesAtValue

G

Gerard

Hi All,
I have just recently started using OWC11 for pivot tables and charts
and am having problems replicating the functionality I find in a normal
Excel Pivot Chart.

My first question is - does an OWC11 pivot chart exactly replicate an
Excel pivot chart.

In Excel I can set the value-axis (y-axis) to 'Cross at' -100 and this
will change how the main plot area is displayed - it has the result of
flipping the plot area BUT keeping how the order of the y-axis is
displayed.

In OWC if I try setting this value it has no effect!
This is an example of the code I am using to set this value

chrt.Charts(0).Axes(0).CrossingAxis().Crosses =
ChartAxisCrossesEnum.chAxisCrossesCustom

chrt.Charts(0).Axes(0).CrossingAxis().CrossesAtValue = -100

'Show values in reverse order' is not an option as this changes the
order of the y-axis.

Any help would be greatly appreciated.
Thanks Gerard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC11 chart axis tick mark label positions 6
Doughnut Chart linked with the slicer in the pivot table 0
Chartspace usage 1
OWC11 .NET Bars seem to be out of order with the Legend 1
Chart column displaying from max down to value instead of from min up to value... 2
OWC11- X Axes 1
NumberFormat code no longer works in OWC 11 on Windows Server 2003 0
OWC11 pivot table export to excel fail: missing tag row (seems to 0

Top