I have a series of 200 days' worth of running totals.
The tricky bit is that "calendar-wise", it covers 1,900 days.

Is there a way to "spread out" the x-axis to "match" the
1,900 days even there are only 200 rows in the series?

For example, using just this data ...
Code:
Row  Day    Total
1    1      45
2    5      72
3    12     87
4    15     89
5    18     125
...   
200  1900   3795
... is there a way to somehow specify
the x-axis such that the chart "paces"
the Total, at intervals based on Day
to mimic a full 1,900 rows such as ...
Code:
Day    Total
1      45
2      45
3      45
4      45
5      72
6      72
7      72
8      72
9      72
10     72
11     72
12     87
...   
1900   3795
... where red indicates data not in
the actual data series.

Natch, a brute force approach would be to add the
missing 1,700 rows (either manually or by a macro),
but I'm wondering if there is a "quick and dirty" way
to specify the x-axis (with just the 200 rows of data).

Spoo