How do you change this Excel Chart "shot numbers"

[Canadianguy]

Here this could work with this file.

[ezplnkr]

The easiest method is to delete rows 54 through 122. You can do this as follows:

1. select row 54 (the row# is displayed on the left of the spreadsheet)
2. using your mouse wheel or the scroll bar on the right of the spreadsheet, scroll down to row 122
3. press the [Shift] key (on your keyboard), keep this pressed as you select row 122; this will select all rows between 54 and 122
4. right-click the selected area (should be highlighted) and a menu will pop up. select 'delete'.

All formulas (as well as the chart) should then auto adjust.

Alternatively, you can manually adjust the chart. This is a bit more involved. If you really wish to go this route, let me know and I can whip up the instructions with diagrams.

(Note that my row reference above are based on the spreadsheet in your attached zip file.)

Cheers.

[Canadianguy]

I love you! lol you did it,just followed you said and it straightned everything out. Thank you very much!

Any tip on how to change shot count higher if wanted?

thanks again!

[ezplnkr]

Any tip on how to change shot count higher if wanted?

This process is the reverse of reducing the shot count; that is, you will have to add rows.

You will have to 'unhide' columns 'I' and 'J' since some adjustment will be required here.

To add one extra row:
1. Copy the penultimate row:
a) right-click on the penultimate row and select 'copy'
b) right-click on the penultimate row (once again) and select 'insert copied cells'
(this will automatically adjust any formulas used throughout the worksheet including the chart)
2. Adjust the cell values of the row you copied in column 'I' (it should equal the cell of the previous row)
3. Adjust the cell values of all subsequent rows (should be only one) following the copied row in column 'J' (ensure the correct sequence)

Cheers.