To Select Items which can't be clicked on in Excel Graphs

[peglor]

Here's one I discovered recently. It makes things a lot easier while working with graphs where the points fit a trendline too closely. If excel won't allow you to select the points on the graph with the mouse, select the trendline, hold down the CTRL key and use the right and left arrow keys to select the different parts of the graph until you get to the series you need.

To get the menu for the selected series, press the right-click menu button on the keyboard (This is usually on the bottom right of a windows keyboard between the CTRL key and the windows button). Right clicking with the mouse will select the trendline again.

 

[joerd]

No need to hold CTRL as far as I'm concerned. Up and down arrow keys also work.
You can also use Format on the top menu bar instead of the keyboard menu key.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.