I have a chart that has three series plotted on it, the first is column
format and the second and third are lines. The first (column) represents
average golf scores for one hole for individuals, the second (line)
represents par, while the third (line) represents overall average for all
golfers.

I can plot the column graph for the 23 competitors - no problem. The problem
is with the two line graphs. I want the lines to extend the width of the 23
columns.

To do this I need 23 points that are the same for each line. I would like to
use something like =player1:player23!$c$323, but I keep getting an error.

I can do something like
=(player!$C$323,player!$C$323,player!$C$323,player !$C$323), but I can only
seem to be able to do this 18 times.

Is there anyway to solve this dilema?

Rudimentary I know, but this represents what I am trying to do.

There are two line which need to extend the width of the chart
There are 23 columns.
___________________________________ line 2

| | | | | | | | | | | | | | | | | | | | | | | | |
--------------------------------------------------line 1
| | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | |
1 1 1 1 1 1 1 1 1 1 2 2 2 2
1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3

Thanks