Setting "Value (Y) axis crosses between categories"

[David Smith]

Hello,

I am trying to find out how to duplicate a specific
property in a Web based OWC chart generator that you can
set in an Excel chart.

-If you create a line chart in excel
-Then Select the X Axis
-Then from "Format" (or right click) select "Format
(Selected) Axis"
-Go to the Scale Tab of the "Format Axis" Dialog
-Then There is a checkbox that is labled "Value (Y) axis
crosses between categories"

If the "Value (Y) axis crosses between categories" box is
checked the first and last series do not sit on the
borders of the chartspace but instead are padded to the
center of each category.

In Excel the
property "Microsoft.Office.Interop.Excel.Axis.AxisBetweenC
ategories" can be set to "true" or "false", but this
property does not exist
in "Microsoft.Office.Interop.OWC.ChAxis".

I have tried working with the "Crosses" property of
the "chAxis" object ("Crosses" Set
to "chAxisCrossesCustom" and then setting
the "CrossingAxis" and "CrossingAtValue" property) but
this seemed ot have no effect other than moving the Y-
axis from left to right across the chart.

Does anyone have any insight to this? Is there something
in the series instead?

Thanks

David Smith
(e-mail address removed)