There are 2 defined names:

x9a with the formula =OFFSET('9 (4)'!$A$5,0,0,COUNT('9 (4)'!$A:$A),1)

y9a with the formula =OFFSET('9 (4)'!x9a,0,1)

This is in Excel 2007.

These is a 2 column data set that displays a column of Month-Year
dates, and the second column contains a monthly count like 4,555.
These two columns vary in length from 1 to 12 months depending on
values in a date selector drop down box.

The chart is a column chart with the Month-Year dates along the x axis
and the values above them.

These are presentation pages with a table of data at the top and a
chart or two charts at the bottom under the table of data.

Thanks and yes, your response is helpful but I don't see the yes
button you are referring to in your message.