Mircosoft Excel question

Discussion in 'General Chat' started by beefpuff, Jun 7, 2007.

0
  1. #1
    Hi all!

    I've entered all my stats for my webpage http://mcbanditt.com into an excel table: Adsense, analytics, etc.

    I can make a line graph for those values, but is there a way where I can get the graph to update automatically when I add new data?

    I'm using Excel 07 but solutions from other versions should work as well. + Rep to anyone who finds the answer.

    Thanks, Alex.
     
    beefpuff, Jun 7, 2007 IP
  2. Crazy_Rob

    Crazy_Rob I seen't it!

    Messages:
    13,157
    Likes Received:
    1,366
    Best Answers:
    0
    Trophy Points:
    360
    #2
    It should just do it automatically.

    How are you creating the graphs?
     
    Crazy_Rob, Jun 7, 2007 IP
  3. beefpuff

    beefpuff Guest

    Messages:
    136
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hey,

    I'm CTRL clicking the colom(s) that I want, and then -> add graph -> Line graph or scatter etc... I've messed around with it more trying different options but it still doesn't work.
     
    beefpuff, Jun 7, 2007 IP
  4. Crazy_Rob

    Crazy_Rob I seen't it!

    Messages:
    13,157
    Likes Received:
    1,366
    Best Answers:
    0
    Trophy Points:
    360
    #4
    I don't know....when I use the chart wizard from the toolbar, it updates the graphs automatically when i change the values.
     
    Crazy_Rob, Jun 7, 2007 IP