Hello,

Please have a look at this chart:



As you can see, the y axis is made from a row of dollar amounts and the x axis is made from dates in the row above it. I'm wondering if there's a way to make Excel a bit smarter when it comes to dates. What I'm looking for is a chart laying out the dates on the x axis but to scale with actual time. For example, you see the first three dates:

Feb 13 2017
Mar 17 2017
Mar 24 2017

They're all spaced evenly apart, but in actual time, Feb 13 and Mar 17 are more than a month apart, and mar 17 and mar 24 are only a week apart.

I'm wondering if Excel is smart enough to do something like this:



So I'm looking for a graph in which the months are to scale with actual time (equally spread out) and the dates fall where they would actually fall in actual time. The coloring of the months would be nice too but I don't need that. The dates on each data point would also be nice but I don't need that either. Just making the dates to scale is all I'm looking for.

Thanks