Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - How do you add charts to a work book

microsoft excel training - How do you add charts to a work book

ResolvedVersion Standard

Tue 15 Jan 2008, 16:25 Delegate Farhat said...

Farhat has attended:
Excel Intermediate course

How do you add charts to a work book

How do you add charts to a workbook

Wed 23 Jan 2008, 11:40 Trainer Katie said...

RE: How do you add charts to a work book

Hi Farhat,

Thanks for your question.

To create a chart, you need to highlight the data table with both Lables & numeric data -> then press F11.

To add a chart from elsewhere, you can simply copy the original and paste on the new workbook.

Hope this helps.

Regards,

Katie

Training courses

98.2 % recommend us

More live stats...

Training information:

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips