Fixed X Axis w/ Variable Range

[rtc123]

Here's one I haven't seen:

How do you, using VBA, create a fixed number of x-axis tick marks (say, 10), even if the data range varies?

I have the following, but it doesn't seem to work:

objChart.Axes(xlCategory).CategoryType = xlCategoryScale
objChart.Axes(xlCategory).FixedScale = 10

 

[rtc123]

Hi Jon,

I am using a line chart. If that's the case, what are the line chart X axis commands?

 

[Jon Peltier]

As I said, "Your problems seem to indicate you're trying to set a line chart X axis using scatter chart X axis commands."

Try using an XY Scatter chart. You can make one with the same formatting as a line chart, that is, with lines connecting data points. The difference is not in formatting of the data, but in treatment of X values by the X axis.