MSChart brain-buster

[P.S.W.]

I'm trying to get all tricky with the MSChart, and I have 2 things I'm trying to figure out:

1. Is there any way to start the Y-axis at some value other than 0? This is so when I use a line graph with high values it doesn't appear at the very top of the chart with a huge empty area under it.

2. This is more of a "how should I approach it?" question. Let me preface:

a. I'm connecting an ADO recordset to the chart
b. The recordset contains data that is sorted by date, but is not continuous (i.e. some dates are missing) - looks like:

1/1/00 - 10
1/3/00 - 15
1/7/00 - 20

etc. (just a rough example)

OK, lets say I want to chart a week's worth of data at a time. If I graph the above, it will show 3 datapoints. What I want is to show 7 datapoints with "0" values for the missing dates. Hmmm. Right now I'm thinking of some really crazy and complicated schemes, so I'd be happy to hear any creative solutions from you experienced folks!

[JHausmann]

Any reason you can't use Excel? Chart is, umm, feature-deprived in comparison.