> Hi heros,
> I am using Excel 2007 and trying to get a label for both y-axis and x-
> axis.
> The vba code should be used as listed below:
> ActiveChart.SetElement
> (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
> ActiveChart.SetElement (msoElementPrimaryValueAxisTitleVertical)
> ActiveChart.SetElement (msoElementDataLabelRight)
> ActiveChart.SetElement (msoElementChartTitleAboveChart)
> Is that anyone can help me to convert the above VBA code in python.
> SetElement is a function, as far as my understanding
> "msoElementPrimaryCategoryAxisTitleAdjacentToAxis" should be constant.
> I tried to find out the constants in win32com.client.constants, but i
> can not find anything.
> import win32com.client.constants as const
> const.msoElementPrimaryCategoryAxisTitleAdjacentToAxis (not work)
> Can someone explain to me why?
> Kind regards,
> Ning Zhang