+ Reply to Thread
Results 1 to 2 of 2

Creating a graph that will update when more entries are added to the table

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    Bristol, England
    MS-Off Ver
    Excel 2007
    Posts
    15

    Creating a graph that will update when more entries are added to the table

    Attached is the spreadsheet in question.

    I'm trying to make a graph of date on the x axis and score to date on the y axis.

    So this will be an up and down thing as when the player fails to finish in top 3 they lose score and when they finish in top 3 they gain score. They could use this graph to track how they've been playing throughout the year, for example.

    i've been trying to create one, but no idea how to link it to the data and so that when more data is added to the table the graph automatically updates?

    Any help is appreciated,

    Cheers,
    Matt
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Creating a graph that will update when more entries are added to the table

    Since there is yet no chart in your file and you're starting out from scratch, have a look here

    http://peltiertech.com/Excel/Charts/Dynamics.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1