Hi All
I have a predefined chart that I want to set the range collection
dynamically from VBA code. That works OK.

A mixed bar-line chart for 12 months of the year on the X-Axis. My problem
stems from variable number of values for each bar/line.

I set the ranges as follows.....

With chSales
.SeriesCollection(1).Values = shSales.Range("B29:B" & BMax)
.SeriesCollection(2).Values = shSales.Range("E29:E" & EMax)
.SeriesCollection(3).Values = shSales.Range("J29:J" & BMax)
.SeriesCollection(4).Values = shSales.Range("K29:K" & EMax)
.SeriesCollection(1).XValues = shSales.Range("A29:A40")
End With

The BMax and EMax ranges are variable length from 1 to 12 values. The X
values are fixed at 12. The problem arises in that the chart displays ONLY
the X-values up to the B or E max vlaues whichever is grerater. I need it
to show all 12 months regardless of how many values for the chart series
there are, and DO not want the lines in the chart to drop to zero for the
remainder of the chart.

It must be possible?

--
Cheers
Nigel