Add Extra Data Points to Chart

[ops_manager]

I have a table with 52 rows, each calculating values associated with a "Week Ending" date. The chart then shows planned and calculated values for Earned Value (EV), Planned Value (PV), and Actual Cost (AC) -- all values are percentages. These series plot just fine.

From my data, I'm able to calculate two possible completion dates (based on the rate of progress). These are the Estimated Duration at Completions: EDAC1 and EDAC2. I want to display these date projections on my chart as dotted lines.

Ideally, I'd like to add these data points as additional series to the original chart. Because these values are calculated, I would rather NOT have to add columns to the data table and create a nested IF statement in the column to create the dotted lines (as I've done in the attached spreadsheet sample. I added the columns ONLY to show how I want the lines.)

Any help is greatly appreciated. Thanks.es_chart.xlsx

[Andy Pope]

It's probably easier to include the 2 columns.

If you want to base those 2 series on a subset of the data you will need to include the 3 dates which have values as well as the start and end date of the main data sets. You can then move the 2 series to the secondary axis and redefine the range used for category labels.

[ops_manager]

Thanks for the reply and the information. I see how to define the date range series to match the original date range does the trick -- this is something I'll definitely keep in mind. But I do agree that I'll likely use the two columns in the table with a nested formula of some kind to set those dates.