How do I create graph showing savings over time?

Hi Caleb,

It looks like you are using a Line Chart (Category Chart).

A Scatter Plot will give a linear X axis. Scatter plots work best when the X and Y data are in Body Columns, not Header Columns.

You can have a Header Row for labels (Date, Savings).

Regards,

Ian.

The only way I can see of "stretching" the x-axis into a regular timeline would be to add extra rows for some of the intervening dates and then averaging the both the dates and the amounts from the row above and the row below:

You can then hide the rows that contain the averaged amounts.

When you create the chart you'll need to tick the "Hidden data" button under Chart Options:

After you've created the chart, you can edit the dates on the x-axis to remove any unwanted labels.

Hope this helps.

H

Hi Caleb,

Back to the Scatter Plot, this approach may work for you.

Formula in A1 (the start date)

=B2

Column C calculates the months since the start date.

Formula in C2 (and Fill Down)

=DATEDIF(A$1,B2,"M")

The difference (in months) between each date and the start date.

Select Columns C and D and insert a Scatter Plot

Gives months on the X axis and savings on the Y axis:

Regards,

Ian.