excel programming vba - Graph intersect

Resolved · Low Priority · Version Standard

Fri 16 Feb 2007, 16:01 Delegate Jennifer said...

Jennifer has attended:
Excel Advanced course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Graph intersect

I need to find the point where 2 lines on a line graph intersect. I've found the "Intercept" function but this only gives a y axis intercept.

Wed 21 Feb 2007, 10:00 Trainer Garry said...

RE: Graph intersect

Change the view of the chart from row view to column view

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

excel programming vba - Graph intersect

Graph intersect

RE: Graph intersect

Excel articles

Excel tip:

Use shortcut keys to select rows or columns