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

advanced excel

ResolvedVersion 2003

Kate has attended:
Excel Advanced course

Advanced excel

how do you put a trend line onto graphs?

RE: Advanced excel

Hi Kate,

Thanks for the post, welcome to the forum, in answer to your question, create your chart as per normal, formatting as necessary, usually you would set a trend line to ascertain how a particular growth pattern is established in a set of data over a period of time. Note; a Trend line can be applied only to a two dimensional chart.
Oh yes, how to do it; select the chart and on the Menu bar choose the Chart option, from the menu choose Add trendline, from the dialog box slect the type of trendline you wish to display, click OK, I hope that helps, if so please click the resolved link, best regards Pete

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

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.1 secs.