Escanaba
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER