Tip #3024 - Cruising Around Your Charts
Printer Friendly Version | E-Mail This Tip
Cruising
Around Your Charts
Use Excel charts?
Find it difficult
to select just the "right" portion of your chart? Or, maybe
you've got the opposite problem. You can select portions easily, but you
can't seem to easily select the whole thing? Tired of the mis-clicks?
Whatever your selection
problems may be, you just might find a solution if you give these a try.
Let's begin big. To
select the entire chart, try Ctrl + a click on the chart.
Now, to the smaller
details. To select a specific section of the chart, give this little trick
a whirl. First click anywhere in the chart, then
use the arrow keys.
Use the up
/ down arrows to quick flip between the major components of the
charts (such as the chart area, plot area, data series, etc).
If you need to get
to specific details within an area (maybe a single bar within the data
series), switch to the left / right arrows once you've
gotten to the correct major area. You'll then find that the selection
begins to go into the details of that area.
At last, a way to
select chart pieces without a bunch of mis-clicks!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
