Re: xlCategory Scale

From: Jon Peltier (jonxlmvpNO_at_SPAMpeltiertech.com)
Date: 03/16/04


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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

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/
>