Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Do I Manually Draw a Line on an Excel Chart?

Status
Not open for further replies.

DMunoz

Technical User
Jan 19, 2001
8
US
I've created a chart in Excel and have formatted the automatic major / minor grid lines as needed. With the data plotted (scattered), I need to visually show the grid in 4 equal quadrants. The problem is that I need the exact center line for both vertical and horizontal to be different from the other vertical and horizontal lines, such as larger and bold. How can I simply change those two lines without affecting the others?

Thanks in advance for the help.
 
I've answered my own question. I finally found the Drawing Tools and simply added the lines. DUH!!!
 
Tip :
If you want a dynamic line that adjusts to changes in Y axis scale, add another range with all the same values, turn off the markers, and make the line big and fat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top