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 » Excel

	98.1 % recommend us
	More live stats...

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

Training information:

Excel

Resolved · Low Priority · Version Standard

Reply Thu 28 Feb 2008, 16:14Delegate Kia said...

Kia has attended:
Access Intermediate course

Excel

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

For upcoming training course dates see: Pricing & availability

Reply Mon 3 Mar 2008, 13:10Trainer Katie said...

RE: Excel Drawing Objects

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)

Excel articles

· Some Lesser Known Time Saving Tips In Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· An Introduction To Financial Functions In Excel 2010
· Make A Custom Sort List In Excel
· Create An Improvised Bar Chart In Excel

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

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips