View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
isofuncurves
 
Posts: n/a
Default ?-Change data series range as data is entered?


I have a chart which shows a prediction curve and an actual curve. The
prediction curve runs out until the end of a project. The actual curve
is populated as data is entered. I will be generating a number of these
charts from a datatable. I would like to plot the prediction curve for
the duration of the project (easy). I would then like to plot the
actual curve with only the existing data and not have the line drop to
the x-axis at the end. Can I put a formula in the data series "x
values" field?

I hope that my description makes sense.....

Thanks,
Carl


--
isofuncurves
------------------------------------------------------------------------
isofuncurves's Profile: http://www.excelforum.com/member.php...o&userid=30749
View this thread: http://www.excelforum.com/showthread...hreadid=504189