I am currently producing a dynamic chart that is populated by a potentially
different sized amount of data.

I have been using Peltier's technicque to create dynamic ranges for the X
values and Y values, and this works fine to a certain extent. However, I want
the X values to incorporate two columns and not the one. For example:

Col M Col N Col O
X Values X Values#2 Y Values
Gender Male 1
Female 2
D-O-B January 1
March 2
April 3
September 4

....etc etc

The named range for the X Values is identified by the following calculation:

=OFFSET('Workbook'!$N$108,0,0,COUNTA('Workbook'!$N $108:$N$200))

Is there a way of slightly amending this so as Column M is also included as
part of the X Range?

Many Thanks