Charts

Resolved · Low Priority · Version 2007

Fri 14 Oct 2011, 10:46 Delegate Susan said...

Susan has attended:
Excel Advanced course

Charts

When creating a chart do you have to put the data labels and chart titles etc on individually from the ribbon or can you do it all together as in Office 2003

Fri 14 Oct 2011, 11:39 Trainer Anthony said...

RE: Charts

Hi Susan, thanks for your query. It is all ribbon based now, I'm afraid. The 2003 version had a rather lengthy wizard to walkthrough chart creation, but from 2007 you need to trigger these settings yourself. If you want it automated, you'll need to pick up some VBA!

Hope this helps,

Anthony

Fri 21 Oct 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

Charts

Charts

RE: Charts

Excel articles

Excel tip:

Hide data in Excel Worksheets

Training Programs
Professional & Management Development