Excel 2007 Adding Dynamic Vertical/Horizontal Lines To Scatter Chart

Hello,

Attached is a scatter chart that I need to add vertical and horizontal lines to show the averages of the two catagories.  The vertical line should be based on cell S18 and the horizontal line on cell T18.  I've looked at a few examples and cant figure out how to create this so any assistance would be greatly appreciated.  The 2nd chart shows you how the 2 lines should appear.

Thanks! EE-Sample.xlsx
LVL 1
EscanabaAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Like so - plot two additional series and change the chart type for those two series to show connecting lines. See attached.
EE-Sample.xlsx
0
 
EscanabaAuthor Commented:
Perfect.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.