Re: xlCategory Scale
From: Jon Peltier (jonxlmvpNO_at_SPAMpeltiertech.com)
Date: Tue, 16 Mar 2004 14:57:12 -0500
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 Peltier, Microsoft Excel MVP
Peltier Technical Services
incjourn < wrote:
> I am using the following code to get a ratio of the scale of the y-axis
> 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 scale
> property is not supported, neither is there a GetSeries method.
> Is there anyway I can get the max and min value of the xlcategories
> and/or the number of values in the xlcategory?
> Message posted from http://www.ExcelForum.com/