Help with windage comparator chart

[Sal]

I hope this doesn't fall on the side of what I can write here, but here goes:
I need some help with making windage comparison charts in Excel, of the type the Editor in Chief uses in his excelent articles:
http://www.6mmbr.com/243Win.html

I need some rough outlines to how I should set up the columns and ad text.
I guess it's pretty much the same set up on both wind and drop, as well as speed.
So this is more a computer issue than a shooting issue I suppose.
I am going to use this for educational purposes, comparing the most common cartridges.
If anyone could sketch me an outline it would be nice, any actual suggestions could be mailed to venstrefot,at) gmail.com

Thanks guys

Sal

 

[Forum Boss]

Sal,

It's pretty easy to duplicate the chart on the .243 page.

Set up the different calibers in a vertical column on the left. Put a legend with the distances from right to left on top. Then fill in the cells with the inch values for the particular distances, based on the output of your ballistics program.

Then highlight the entire chart, including the distance legend in the top row.

Click on the Chart Wizard tool in Excel and select LINE and the version shown below. Then you may have to play around a little with the labels to get what you want, but the values should display correctly.

 

[Sal]

Thanks a lot !
I think I got the hang of it now.