Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Charts

Resolved · Low Priority · Version 2003

Reply Thu 28 Aug 2008, 16:30Delegate Gary said...

Gary has attended:
Excel Intermediate course

Charts

Pleaase can you tell me how to insert a chart

For upcoming training course dates see: Pricing & availability

Reply Tue 9 Sep 2008, 11:25Trainer Mark said...

RE: Charts

Hi Gary

How are you doing, sorry for not responding sooner

The quickest way to insert a chart would be as a new sheet, to do this select the cells you want in the chart, then press the F11 key on your keyboard

NB: if you then want this on the same sheet as your data,
go to the chart menu and click location - then click - as object in - then click OK

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel articles

· Easing the Transition to Excel 2007
· Discover The Difference Between Line And XY Scatter Charts In Excel
· The Mysteries Of Excel Explained
· Using Dates Within Excel
· More Tips From Excel's Rarely Used File

Please browse our web site to find out more about
excel-training-advanced courses and other Microsoft training courses.

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips