Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

graphs

ResolvedVersion 2003

Paula has attended:
Excel Introduction course
Word Introduction course

Graphs

is there a short-cut key for graphs

RE: graphs

Hi Paula,

Thanks for your question and welcome to the forum.

The shortcut key to create a new graph on a new sheet is F11 (Function Key 11) at the top of your keyboard.

Thanks and kind regards

Maggie

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.