charts

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

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

Charts

resolvedResolved · Low Priority · Version 2003

Gary has attended:
Excel Intermediate course

Charts

Pleaase can you tell me how to insert a chart

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 tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.09 secs.