Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel courses london - piechartsgraphs

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Piecharts/graphs

microsoft excel courses london - Piecharts/graphs

ResolvedVersion Standard

Louise has attended:
Excel Intermediate course

Piecharts/graphs

How do you add a piechart and a bar / column chart on one worksheet?

RE: piecharts/graphs

Hi Louise,

Thank you for the question.

I suggest you use the Chart wizard and create two charts, both the pie chart and the column chart. However when you get to the last stage of the wizard click as an object in a new sheet. In this way you can include two charts on one sheet.

Hope this helps, anything else please get back to me

Tracy

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

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

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.