excel course in london - graphs
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course in london - Graphs

excel course in london - Graphs

resolvedResolved · Low Priority · Version Standard

replyReply Mon 19 Feb 2007, 13:00Delegate Victoria said...

Victoria has attended:
Excel Intermediate course

Graphs

How do I compare two graphs?

For upcoming training course dates see: Pricing & availability

replyReply Tue 20 Feb 2007, 14:31Trainer David said...

Comparing Graphs in Microsoft Excel

Hi Victoria

You can create a new line graph that plots both sets of data, then you will have all the data on one graph.

Hope this helps

David

 

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard