MS 2016 Excel Chart

[deepak004]

Hi,

Looking for some help on excel chart without using VBA codes (if possible).
Team :1 $0.27,
Team :2 $0.90,
Team :3 $4.63,
Team :4 $5.32,
Team :5 $0.77,
Total $11.88,
Above table provide total expenditure forecast for each teams for a future event. The data which will update on daily basis. I would like to plot a Line Graph to show progress/update for each day without expanding the table any further. Spending forecast for each team will change everyday & old data will be replaced with new.
My X-Axis will be date & Y-Axis will be spending.
Ques: Is excel 2016 capable of generating a Line Graph with data getting replaced (overwritten) everyday ? If yes, can some please help me here !!
In addition,
when old data is replaced with new ,,, only dots on line graph moves & aligns with new date,,, without creating a line graph

Appreciate your help.
Thanks

 

[Jon Peltier]

You want to show progress, meaning along a date axis? You will need to capture that somehow in the data. If team names are in the first column, then you need dates in the first row, and corresponding dollar values in the grid defined by these.

You need to set up the data, and the chart will work out right.