xlCategory Scale

  • Thread starter Thread starter incjourn
  • Start date Start date
I

incjourn

I am using the following code to get a ratio of the scale of the y-axi
on the chart.

vHeight = .InsideHeight
yMn = ActiveChart.Axes(xlValue).MinimumScale
yMx = ActiveChart.Axes(xlValue).MaximumScale
yRatio = vHeight / (yMx - yMn)

I want to do the same for the xlcategory axis but the .Maximum scal
property is not supported, neither is there a GetSeries method.

Is there anyway I can get the max and min value of the xlcategorie
and/or the number of values in the xlcategory
 
You can set these properties in an XY Scatter chart, which has a value
type category axis.

In a category type category axis, the number of categories comes from
the .Points.Count property of a series.

- Jon
 
Back
Top