deepak004

New Member
Joined
Jan 20, 2015
Messages
2
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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,064
Messages
5,472,249
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top