Target Line on graph from just 1 value

[s_pochedly]

I am trying to chart out actual (performance) data points against target on a graph. Is there a way to produce the target line from just 1 value? It would be assumed all the performance variables would be put against that target. I just don't want to create another row below the performance data row, with a corresponding target for each because the target is the same for all those data points. However in graphing, Excel thinks there is only one data point for target in that series, so it only graphs that one point. I would like it to instead graph it for every performance data point, but just put the target in one cell. The reason for this is really just to streamline the data entry and compress that sheet by not having to add the helper rows.

 

[awoohaw]

What kind of chart? It would be very helpful is you shared some data, and possibly an image what you expect?

 

[s_pochedly]

It's a line graph, sorry.

first pic (SS1) depicts what I want - I would have the target for recordable cases and near misses in B7 and B8 respectively. C8:P7 would all share the goal listed in B7. Same with row 8 respectively.

2nd pic is the way I don't want to do it - adding the helper row (row 9) with a target for each month.

This section might not seem like a big deal because the target is the same for both metrics, so I technically only need 1 helper row for both those. However if you think about having multiple machines and welders, each of which we'll be measuring 5-6 different things with their own targets, that's where I'll run into having to add tons of helper rows.
---> see SS3 for a picture of this.

Finally, I'm adding image SS4 to illustrate...the orange line is target which is 0 in this example. But the point of the post is, I want to make that line based off just 1 cell, omitting the helper columns as I describe above.

Appreciate any help.