Thread: 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

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?