Graphs

Resolved · Urgent Priority · Version 2010

Mon 13 Jun 2016, 10:53 Delegate Divya said...

Divya has attended:
Excel Intermediate course
Word Intermediate course
Excel Advanced course

Graphs

Hi,
I have set up a graph with columns and I need to have totals at the top of each column.
Please can you advise.

Mon 13 Jun 2016, 11:30 Trainer Jens said...

RE: Graphs

Hi Divya,

Thank you for the forum question.

Select the graph and click on the Layout tab on the ribbon.

Click on Data Labels and here you will find the options you need.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 20 Jun 2016: 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

Graphs

Graphs

RE: Graphs

Excel articles

Excel tip:

Freeze Rows and Columns to keep lables displayed