+ Reply to Thread
Results 1 to 9 of 9

Create a Dynamic Chart from an Excel Table

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Create a Dynamic Chart from an Excel Table

    I want that if I write new data in table then may chart should be supplemented with this data automatically. What I have to do?
    Last edited by Elīna; 07-29-2013 at 09:06 AM.

  2. #2
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    my chart

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    And sorry about my english..

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Table and chart

    Hello Elina
    I know it's difficult when English is not your main language but take a look at the link below it might be of some help.

    http://www.techrepublic.com/blog/mso...arts-in-excel/

    Also, the moderators might wish you to change your post title to something more descriptive, as per forum rule #1. Maybe, something like: 'Create a Dynamic Chart from an Excel Table'.

    Hope this helps.
    DBY

  5. #5
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    Quote Originally Posted by DBY View Post
    Hello Elina
    I know it's difficult when English is not your main language but take a look at the link below it might be of some help.

    http://www.techrepublic.com/blog/mso...arts-in-excel/

    Also, the moderators might wish you to change your post title to something more descriptive, as per forum rule #1. Maybe, something like: 'Create a Dynamic Chart from an Excel Table'.

    Hope this helps.
    DBY
    Thanks, DBY. It helps a little bit. I get it for one column only yet. My data at the moment is in columns A:AL. When I write data in column AN, it works, but in AO not anymore.

  6. #6
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    For chart I have to mark only that data I already have or area in where the data are planning to be too? Because previously I have been marked larger area and that's why that the method works.

  7. #7
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    Up up up up

  8. #8
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Table and chart

    Quote Originally Posted by DBY View Post

    Also, the moderators might wish you to change your post title to something more descriptive, as per forum rule #1. Maybe, something like: 'Create a Dynamic Chart from an Excel Table'.
    How can I change the title?

  9. #9
    Registered User
    Join Date
    07-29-2013
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Create a Dynamic Chart from an Excel Table

    Ok, I found. First day here.

  10. #10
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Create a Dynamic Chart from an Excel Table

    Hello
    As you have started another post based on this question here:

    http://www.excelforum.com/excel-form...-in-excel.html

    and have received replies from forum members there, it might be better to continue in that post and do as Marcol suggested and upload a sample file.

    Regards
    DBY

+ 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. Pivot Table Border and Pivot Table Chart Formatting
    By Fish10800 in forum Excel General
    Replies: 0
    Last Post: 06-20-2012, 11:09 AM
  2. Replies: 0
    Last Post: 09-01-2011, 12:07 PM
  3. Replies: 3
    Last Post: 09-11-2010, 06:55 AM
  4. Replies: 1
    Last Post: 04-14-2010, 07:38 PM
  5. How to display a series in chart table and not in the chart?
    By Mani in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2006, 12:45 PM

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