I downloaded this chart online and have tried tweaking it a bit. Not knowledgeable enough for it.
Right now it shows 5 shots in rows in the data table, but only shows 3 on the chart.
I have added shot rows 6 - 10 in the For Printing and After action Input worksheets, and redone some
of the equations as they all didn't just copy over.
Don't know if it is possible too have 10 shots or as many as I need up to 10,ie.3, 5, 8 etc.
Sometimes a shot won't register on the chronograph so some loads may have less than ten shots.
The graph only shows the 3 shots as well as Avg. and Median Velocity.
I would like the chart/graph show all inputted and the legend moved to the outside Left of the chart.
I'm not good at excel yet still learning but have tried everything to have the chart show all 12 inputs.
Maybe it's impossible to redo the chart in Excel 2007. I suspect that it was designed in a newer version.
Someone did a lot of work on this and I am trying to improve it somewhat.
Not in any hurry as I can use it in a partial way just graphing the 5 inputs.
I even have the Excel 2007 for Dummies book and it's getting dog eared, along with headaches LOL.
PS this form is not copyrighted it was put on a forum for anyone to download and use.
Bookmarks