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

Charts

ResolvedVersion 2003

Mon 17 Nov 2008, 16:36 Delegate Sally said...

Sally has attended:
Excel Introduction course

Charts

How do I create a target line, and actuals column on a timeline?

Fri 5 Dec 2008, 16:47 Trainer Amanda said...

RE: Charts

Hi Sally

Thank you for your question and welcome to the forum.

Are you referring to having your actuals represented in columns; and the target figures represented in a line?

Thanks
Amanda

Thu 18 Dec 2008, 09:21 Trainer Rich said...

RE: Charts

Hi,

We are clearing some of the outstanding questions in the forum. As this post has been inactive for quite some time, the system will automatically set the post to 'resolved' in the next 5 days unless a follow-up post is made within that time.

You can always mark the question as 'unresolved' at any point if you require further assistance with this matter.

Regards,
Best STL Forum Team

Wed 24 Dec 2008: Automatically marked as resolved.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Charts

Charts

RE: Charts

RE: Charts

Excel articles

Excel tip:

Freeze Rows and Columns to keep lables displayed