Rob

You will need to define 7 Ranges

1 for the X-Axis and

6 more, 1 for each data Range you want in your chart

The XAxis named range will be be

=OFFSET(Sheet1!$E$6,0,0,1,COUNTA(Sheet1!$E$6:$BQ$6))

The Named Data Ranges will be

for Data Range 1

Data1 = Offset(XAxis,1,0)

where the value 1 will be changed to represent the number of rows the Data Range is below the X-Axis Range

Repeat this for the 6 Ranges of Data you are graphing

Once you have your named Ranges Set-up, whilst still in the Named Ranges Dialogue, select each named ranges and click in the equation box, That will show you that it is selecting the correct data, Adjust the formula's if it isn't.

Now go back to your chart and in sequence select each Range by selecting the appropriate bar

The equation box will show something like

=SERIES(,Sheet1$E$6:$BQ$6,Sheet1!$E$7:$BQ$7,1)

There may be a Range or Text in front of the First Comma

In the equation Box you need to edit the formula to be like

=SERIES(,Book1!XAxis,Book1!Data1,1)

Where XAxis and Data1 are the named ranges you defined earlier

Adjust the Book1 name to be whatever your Spreadsheet is called

Leave whatever is in front of the first ,

Do the same to all the bars

The Chart won't change until you have done them all as the longest range will define the X-Axis length