Hi,

I have a line chart with 2 data series. One for actual balance and one for
budgeted balance. The y-axis is $ amount, the x-axis is month. There are 12
points on the x-axis. (Jan to Dec). I have 12 data points for the budgeted
balance. I'm using a dynamically named range for the # of data points for the
actual balance series based on the current accounting month. (Jan shows 1
point, Feb shows 2 points etc.)

I'm trying to add a 3rd series for Projected balance which would start where
the actual balance stops. I have another dynamically names range as the data
source. I have already calculated figures for the Projected balance.

My problem is that it correctly plots the May $ amount but it plots in
January on the x-axis. Is there an offset somewhere that will allow me to
move the starting point for the Projected series line?

--
TIA
Chuck M.