In previous post I ask about sorting on Xaxis.
I have a chart that will have 24 data points. 2 years in months. Counting down on the XAxis Months Remaining 23, 22, 21,... 3, 2, 1, 0
At the beginning of the project I will only have 1 month of actual data. Each month I need to add data to the chart, but the chart always needs to represent all 24 data points so i can put a target line all the way to the end of the charts time period. (basically it's a visual representation of "Hey gang, might want to get going, kind of lagging behind the effor here ya know".)
I'm expecting I'll have 4 lines. Including projected trend line and target line from month 23 to month 0, and then two more that will only have data up to the current month.
Some if not all of the data points will be null as the project progresses.
Suggestions?
I have a chart that will have 24 data points. 2 years in months. Counting down on the XAxis Months Remaining 23, 22, 21,... 3, 2, 1, 0
At the beginning of the project I will only have 1 month of actual data. Each month I need to add data to the chart, but the chart always needs to represent all 24 data points so i can put a target line all the way to the end of the charts time period. (basically it's a visual representation of "Hey gang, might want to get going, kind of lagging behind the effor here ya know".)
I'm expecting I'll have 4 lines. Including projected trend line and target line from month 23 to month 0, and then two more that will only have data up to the current month.
Some if not all of the data points will be null as the project progresses.
Suggestions?