Graph from one cell which changes

DID

New member
Joined
Jan 14, 2014
Messages
15
Reaction score
0
Points
0
Hello everybody,

I have a small challenge, which I cannot solve myself.

I have data in an excel file, which is entered continously (the data is performance). Now to analyse the data, I have created a formula that gives me the last 10 entries average. This average is written in a cell (e.g. C3), and obviously changes everytime new data is entered. Now I would like a graph to show this average (right now it is just shown as a single column). I would like the presentation graph to be continous, for examlpe to read the cell, put the point on the graph, and when the cell is changed to put a new point, while still showing the last one. The x-axis should be e.g. 30 days, and Y-axis is the data.

The performance data is entered once a day.

I really hope you can help me with this.
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
Could you provide us with a file?
 

DID

New member
Joined
Jan 14, 2014
Messages
15
Reaction score
0
Points
0
File

I have now inserted an example file, with data (which is being edited once a day, i.e. it expands downwards).

The 10-day average is showing the last 10 entries average (regardless of the empty cells).


The single column is representing the 10-day average.

NOW I would like the column to become a graph, that "remembers" the last (say) 30 10-days averages.

I hope it makes sense!

-Thanks
 

Attachments

  • Trial.xlsx
    12.1 KB · Views: 13

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
Will look at this Monday (Uk)
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
See attached.
 

Attachments

  • ExcelGuru2873Trial.xlsx
    13.6 KB · Views: 25

DID

New member
Joined
Jan 14, 2014
Messages
15
Reaction score
0
Points
0
Many many thanks!
 
Top