Assign x axis charts values

[gwandalf]

Hi everyone.

I would like to know how can I plot my x axis of a chart with the maximum and minimum value that I have in this variable. Note that my variable is no going from the lower value to the highes one, it is random. So what I did is to use the autoscale of the chart, but it is not working as I would like. Any solution?

The code that I use is:

' TO GET THE INITIAL and FINAL VALUE and the STEP

Worksheets(wsheet(27)).Activate
ActiveSheet.ChartObjects(chartName(11)).Activate
ActiveChart.Axes(xlCategory).MinimumScaleIsAuto = True
ActiveChart.Axes(xlCategory).MaximumScaleIsAuto = True
ActiveChart.Axes(xlCategory).MajorUnitIsAuto = True
xScaleMin = ActiveChart.Axes(xlCategory).MinimumScale
xScaleMax = ActiveChart.Axes(xlCategory).MaximumScale
xScaleStep = ActiveChart.Axes(xlCategory).MajorUnit

'After I use them (xScaleMin,xScaleMax,xScaleStep) for several charts, in this way:

ActiveSheet.ChartObjects(chartName(11)).Activate
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Text =VarName
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Select
ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Font.Size = 11
ActiveChart.Axes(xlCategory).MinimumScale = xScaleMin
ActiveChart.Axes(xlCategory).MaximumScale = xScaleMax
ActiveChart.Axes(xlCategory).MajorUnit =xScaleStep

' but if my data was between 50 and 250 it is plotting between 0 and 300

Thanks[

 

[Andrew Poulsom]

You're not making any changes to the minimum and macimum scales there. This may help you:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

 

[gwandalf]

Thanks. I found the way to do it, with the MAX and MIN. I was not understanding well the way that the axis were working