I have a chart with a single line that sometimes only has a few data
points. The X values are not always evenly spaced. An X-Y chart will get
the X-axis properly scaled, but I like the solid color below the line as
done in an area chart. Can I get both at the same time?

I also notice that an X-Y chart takes the X-axis beyond the highest value.
The area chart automatically stopped at the last point. I assume I can use
this:

ActiveChart.Axes(xlCategory).MaximumScale = [the x-value of my last point]

but is there an automatic way?

Thanks, Don <donwiss at panix.com.

Hi Don,

The Area chart x axis is normally a category axis.
However you can change the axis to be a Time-Scale, which depending on
your data values, will give you scaled spacing.

Cheers
Andy

Don Wiss wrote:

I have a chart with a single line that sometimes only has a few data
points. The X values are not always evenly spaced. An X-Y chart will get
the X-axis properly scaled, but I like the solid color below the line as
done in an area chart. Can I get both at the same time?

I also notice that an X-Y chart takes the X-axis beyond the highest value.
The area chart automatically stopped at the last point. I assume I can use
this:

ActiveChart.Axes(xlCategory).MaximumScale = [the x-value of my last point]

but is there an automatic way?

Thanks, Don <donwiss at panix.com.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info