Tracking line graph

kentleywiltshire4 

untested...

Without having more detailed information available, I could imagine that one way to track the daily savings in your Excel sheet is to use a PivotTable.

A PivotTable can summarize your data by date and calculate the total savings for each day.

Here’s how you can do this:

1. Make sure your data is organized in a table with columns for Date and Savings.
2. Click on any cell in your data table and go to the “Insert” tab in the ribbon. Click on the “PivotTable” button.
3. In the “Create PivotTable” dialog box, make sure the “Select a table or range” option is selected and that the “Table/Range” field shows the correct range of cells for your data table. Choose where you want to place the PivotTable and click “OK”.
4. In the PivotTable Field List, drag the “Date” field to the Rows area and the “Savings” field to the Values area. By default, Excel will sum the values in the Savings column for each date.
5. You can now see the total savings for each day in the PivotTable.

You can then use this PivotTable as the source data for your line chart to show how your savings are aligning with your target over time.

Maybe this helps 🙂