Hello,

I've read the dynamic column chart example on http://peltiertech.com/Excel/Charts/Dynamics.html
but keep running into the same error:

"A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range....etc"

This error appears when I try to change the Series formula to the
range names ChartValues and ChartLabels.

I've gone to the length of even copying formulas for the range names
from the Peltiertech example and still no luck. I've checked my range
names just in a formula. For example, I've typed "=ChartValues" and
when I open (F2) and hit F9, I see the array of data I want. Same with
"=ChartLabels" the array I want with labels. Both have the same number
of items so it's not like one has 15 and the other 16.

Any suggestions as to what I am missing???

Below are my ranges:

ChartLabels
=OFFSET(Sheet1!ChartValues,0,-1)
={"P1";"P2";"P3";"P4";"P5";"P6";"P7";"P8";"P9";"P1 0";"P11";"P12";"P13";"P14";"P15"}

ChartValues
=OFFSET(Sheet1!$B$1,1,0,COUNTA(Sheet1!$B:$B)-1,1)
={25;26;23;22;19;26;27;25;28;31;30;45;24;28;29}