Insert horizontal target line in Line chart - Excel

I have the following data set (sample) with scores for A, B, and C. I've created a Line chart using this data. I now need to add a horizontal target line that spans the chart, using the value in the Goal column. I've tried the approach of creating a chart with all values, then selecting the Goal value and changing the Series Chart Type. This is not working, as it's changing the entire chart. Any help would be appreciated. Thanks in advance.

Measure      A      B       C      Goal
C01              51      55      60      50
isaacr25Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mebaby333It AdminCommented:
0
MajorBigDealCommented:
You can display 2 series of data on the same line chart.   The first series would be called Scores and would only contain the score data.  The second series would be Goal and would contain the goal values.  

The easiest way to make the extent of the "Goal" line to be the same as the "Score" line is to simply repeat the Goal value the same number of times as you have Score values.  I know that is a kludge but it is easy and the chart looks nice that way.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
helpfinderIT ConsultantCommented:
you can use the Goal value as secondary value - check my sample
chart.xlsx
0
5teveoCommented:
oops! late to the answer party!!!! haha...

Make Goal for each 'C##' pattern  its own series of numbers... so A,B,C would have values of 50

so maybe add 2 columns and repeat in 50 (or whatever value) in new columns then
Create 2 graph series
Graph #1 would be series for ABC
Graph #2 would be series for G1, G2, G3

Measure, A,    B,   C, G1, G2, G3
 C01,   51,51,60, 50, 50, 50
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.