+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Sorting data automatically and plotting into graph

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Sorting data automatically and plotting into graph

    Hi. I would appreciate some help on my issue.

    How do I take a user entered value (dynamic) in Sheet 2 into a table in Sheet 1 and sorting it from small to large value and updating the graph in Sheet 2 automatically?
    From my attached excel file, you will see the "Please enter pin size" entered as "0" and the graph horizontal axis is not sorted I would like to see the "0" being sorted to the front.
    Likewise if I have enter "410", I should be able to see it between 410 and 420.Sling Calculation 2.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365

    Re: Sorting data automatically and plotting into graph

    I have included a macro to your file that can be used to sort the data after it is entered. This will update your graph and keep your data in order.

    Hope this helps?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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