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

excel graphs

ResolvedVersion 2003

Michael has attended:
Excel Intermediate course

Excel graphs

How do I create a graph from the scratch or rather: based on the information in a given data base.

RE: Excel graphs

Hi Michael,
Thank you for your post and welcome to the forum;
In answer;
The accepted method of creating a chart is to select the data you wish to chart and from the Standard Toolbar select the Chart Wizard, on the wizard you can follow through and build your chart as required, ie Type, Style, Headings, Layout etc etc. You will then be given the option to display the chart on the current sheet or on a new sheet.
To create a 'quick chart' select the data and press the F11 key (Function 11) on your keyboard, this will create an instant chart which is placed on a new worksheet, you can now format/change this to your requirements. I hope that has helped, if so please click the resolved link, regards Pete

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

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.