excel graphs

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel graphs

Excel graphs

resolvedResolved · Low Priority · Version 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:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips


Server loaded in 0.09 secs.