Excel - organizing data to put in a chart?

Question

Need to chart different bullets' drop in height as it travels. I don't know how to line up the data for each different bullet type in the columns. Any advice? Websites out there?

Answer 1

Sounds like what you're trying to do is parse the data.
1. While Excel is open, select/highlight the column the data is located in.
2. Click on Data --> Text to Column
3. A wizard pops up, choose Fixed Width

If you want to just sort the column in Ascending or Descending order, then just simple.
1. Highlight the column where the data is
2. Click Data --> Sort

Answer 2

Highlight the data then go to "data" then sort and figure out how you want the data sorted. After the data is sorted, you can then work it into your graph/chart the way you want.

Also, if this is not what you were looking for, if you go to help in Excel, and you are on the internet, Microsoft can walk you through it via their Excel website.

Answer 3

Barnes Ballistics
http://www.1000files.com/Home_and_Education/Hobbies/Barnes_Ballistics_3956_Review.html

Calculate trajectory, velocity, wind deflection, striking velocity and other variables with any loads you desire. Find out how altitude, temperature, barrel length, humidity and other factors affect bullet flight. Calculate recoil forces, and determine the optimum zero for your gun and load. As always, this information can be graphed and printed for easy interpretation of the data. A complete online help directory is included for your convenience.

Barnes Ballistics software offers the capability to calculate information in standard or metric form. The user is given the option of which figures to calculate as standard or metric. Put your calculations to the bench test by accessing "Target Shoot". Set your aim for a given trajectory table you are working with, fire and see where the bullet will impact the target at any given distance to target and wind. A fun, virtually realistic way to gain knowledge on bullet trajectory and shot placement for adults and kids!

The database has been expanded to include sections for the user to input and store specific gun, load, powder, bullet and accuracy data. The product listing has been updated to include all of the latest Barnes products for quick reference. Tables can now be calulated out to 50 columns in your choice of measured increments. Barnes Ballistics Version 2 is used by top ballistic authorities for personal, industry and military applications

Related software:
barnes, bullets, ballistics, software, reloading, trajectory, wind, deflection, hunting, shooting, ...

Answer 4

Try this site.