Adding A Measure in a Column

[Sphinx404]

I realize the title of the post is not congruent with what I suppose about data modelling...

However, I am trying to capture a measure in a column rather than calculate 15 different measures just so my chart looks like it needs to.

First, I am using excel 2016, and not PowerBI

I have a chart of stacked columns each representing different value streams. Each piece represents Defects Per Unit. stacking to show the total.


I am trying to add the actual DPU (total of the 3 value streams), baseline and target to the graph visually representing a SINGLE solid line for both. However, I get 3 different lines based on the 3 different value streams for the baseline and the target. 9 lines in total. I just want a single line that represents the whole... not all 3 value streams.

My thought was to create 3 columns based on dates. I.E:

January 2018, this was the actual DPU (the same value in each cell for the entire month of January), in February, this was the actual DPU (same value for all February entries), etc. Same for baseline and target.

I can think of no other way to do this. So:

#1 . How do I add the columns, what would be my calculation? (=if([date]="January",0.58",blank())

#2 . Is there a better way?

Thank you guys!