Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automtically change ranges in formulas when new data is entered | Excel Worksheet Functions | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
how do I change the data series an an excel graph | Charts and Charting in Excel | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |