Excel

The UK's most regular instructor-led training courses.
Training information: microsoft/access/training/courses · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Kia has attended:
Access Intermediate course

by - delegate Kia [1 post] (2008 Feb 28 Thu, 16:14) Reply

is there a way to draw a trend line on a graph up to a certain point (mid way) then draw a second trend line from where the last one finishes to see whether from a certain date the trend has been going up to down

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel Drawing Objects

by - trainer Katie gold contributer [208 posts] (2008 Mar 3 Mon, 13:10) Reply

Hi Kia,

Thank you for your question.

You can draw lines on Excel graphs using Drawing Toolbar.
1) View menu > Toolbars > switch on "Drawing"
2) On the Drawing toolbar, click on straight line icon
3) Click & drag a line on graph, leave mouse when finish
4) You can change the lenght, angle, thickness, colour, style using the drawing toolbar.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another X question?

Have a great day.

Regards,

Katie Woo
(Microsoft Office Specialist Trainer)

· Microsoft Excel's Best Kept Secret
· How to Create Better Excel Spreadsheets: Part Four
· MS Excel: Excel At Making The Most Of Your Christmas
· Compare Different MS Excel Training Methods
· Microsoft Office and the Small Business: Part 1 Excel

Please browse our web site to find out more about
microsoft/access/training/courses and other Microsoft training courses.

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