set valueAxis to get axis axis type value axis ¬
which axis primary axis
tell valueAxis
set major unit is auto to true
set major tick mark to tick mark none --options are:¬
--tick mark cross / tick mark inside / tick mark none / tick mark outside
set minor tick mark to tick mark none
set tick label position to tick label position high --places value labels (ie. the scale) outside the chart
(*options are: tick label position high/tick label position low/tick label position next to axis/tick label position none*)
set maximum scale to 1
set minimum scale to 0
set has title to false
end tell
--::End Tell -- (telling chart of oChartObj)
If you are telling a chart sheet, there is a difference:
set myChart to (make new chart sheet at end of active workbook with properties {name:.....})
tell active chart
--::this line gets the data for a series
make its series with properties {series values:-insert ref-, xvalues:-insert ref-, name:-insert ref-}
set size with window to true
--set chart type to line chart
set chart type to xy scatter smooth
set the_x_Axis to (get axis axis type category axis ¬
which axis primary axis)
tell the_x_Axis
set major unit is auto to false --etc.etc.
end tell
end tell
I hope this answers your question regarding Excel.
Regarding Python...nfc, sorry.