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.