+ Reply to Thread
Results 1 to 2 of 2

Line Chart auto update with new entry

  1. #1
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Line Chart auto update with new entry

    attached is my sample spreadsheet to help clarify this. (i hope)

    I'm looking to create a line chart that will automatically update as new 'entrys' are posted. but i'm also having trouble getting the right data in the right spot.

    the x axis will be the DATA COMPLETE. the y axis will be COMPARISON. there are 5 possible TEAMS that will be entered in weekly. I want the chart to show a line for each team and to add a point on the chart when the data is entered.

    Can a chart sort and organize by a value? in the attached example, in rows 22 thru 37, there are varies entrys for all different teams. But i need the chart to combine all TEAM A's, B's, C's etc.

    hope this makes sense.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Line Chart auto update with new entry

    Given the way that you have your data organized, the best way to do this is with a pivot chart. See the chart I added to the right of your existing chart.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto update graph with new entry
    By tactical in forum Excel General
    Replies: 0
    Last Post: 10-09-2012, 12:01 PM
  2. [SOLVED] chart auto update
    By navwelch in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-02-2012, 08:01 AM
  3. Update line chart series colors
    By Apple Ling in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2010, 05:10 AM
  4. [SOLVED] How, on a line chart, to skip blank entry rather than plot as 0?
    By JohnTerp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2006, 06:15 PM
  5. auto update of a chart
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 05:00 AM

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