software

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 quot;x
valuesquot; field?

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

Thanks,
Carl--
isofuncurves
------------------------------------------------------------------------
isofuncurves's Profile: www.excelforum.com/member.php...oamp;userid=30749
View this thread: www.excelforum.com/showthread...hreadid=504189Hi,

Sounds like you need to use a dynamic named range for the chart data
source. Here are a collection of webpages on the subject.

peltiertech.com/Excel/Charts/Dynamics.html
www.tushar-mehta.com/excel/ne...rts/index.html
www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

isofuncurves wrote:
gt; I have a chart which shows a prediction curve and an actual curve. The
gt; prediction curve runs out until the end of a project. The actual curve
gt; is populated as data is entered. I will be generating a number of these
gt; charts from a datatable. I would like to plot the prediction curve for
gt; the duration of the project (easy). I would then like to plot the
gt; actual curve with only the existing data and not have the line drop to
gt; the x-axis at the end. Can I put a formula in the data series quot;x
gt; valuesquot; field?
gt;
gt; I hope that my description makes sense.....
gt;
gt; Thanks,
gt; Carl
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Andy,

Thank you. That is exactly what I was looking for. I do have one
ploblem with the solution though. My data table contains formulas to
generate the chart data. So CounA() is not working for me. Each cell,
inclulding the quot;empty onesquot; contains a formula:

I am defining my series by:
gt; =OFFSET('CIP CMG'!$G$3,0,0,COUNTA('CIP CMG'!$G:$G)-1)
gt; =OFFSET('CIP CMG'!$I$3,0,0,COUNTA('CIP CMG'!$I:$I))
gt; =SERIES('CIP
gt; CMG'!$H$3,Metrics.xls'!CIP_Date,Metrics.xls'!Sum_T arget_Start,2)

The data for the named ranges is not entered manually. It is generated
by a formula.
gt; =IF(G21lt;=TODAY(),COUNTIF(C$2:C$91,quot;lt;quot;amp;$G21),quot;quot;)

I assume COUNTA does not work because the cells are non-empty. Any
ideas how to make this work with formulas in the cells?

thanks,
Carl.--
isofuncurves
------------------------------------------------------------------------
isofuncurves's Profile: www.excelforum.com/member.php...oamp;userid=30749
View this thread: www.excelforum.com/showthread...hreadid=504189Have you tried COUNT() instead of COUNTA()?
isofuncurves wrote:
gt; Andy,
gt;
gt; Thank you. That is exactly what I was looking for. I do have one
gt; ploblem with the solution though. My data table contains formulas to
gt; generate the chart data. So CounA() is not working for me. Each cell,
gt; inclulding the quot;empty onesquot; contains a formula:
gt;
gt; I am defining my series by:
gt;
gt;gt;=OFFSET('CIP CMG'!$G$3,0,0,COUNTA('CIP CMG'!$G:$G)-1)
gt;gt;=OFFSET('CIP CMG'!$I$3,0,0,COUNTA('CIP CMG'!$I:$I))
gt;gt;=SERIES('CIP
gt;gt;CMG'!$H$3,Metrics.xls'!CIP_Date,Metrics.xls'!Sum _Target_Start,2)
gt;
gt;
gt; The data for the named ranges is not entered manually. It is generated
gt; by a formula.
gt;
gt;gt;=IF(G21lt;=TODAY(),COUNTIF(C$2:C$91,quot;lt;quot;amp;$G21),quot;quot; )
gt;
gt;
gt; I assume COUNTA does not work because the cells are non-empty. Any
gt; ideas how to make this work with formulas in the cells?
gt;
gt; thanks,
gt; Carl.
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


I thought of using countif() since all will be numeric integers gt;0. I
haven't tried it yet as I'm scrambling to put together a
presentation... Thanks!

Carl--
isofuncurves
------------------------------------------------------------------------
isofuncurves's Profile: www.excelforum.com/member.php...oamp;userid=30749
View this thread: www.excelforum.com/showthread...hreadid=504189