Results 1 to 6 of 6

Thread: Graph from one cell which changes

  1. #1

    Graph from one cell which changes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    Could you provide us with a file?

  3. #3

    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
    Attached Files Attached Files

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    Will look at this Monday (Uk)

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    See attached.
    Attached Files Attached Files

  6. #6
    Many many thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •