Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Excell

microsoft.excel.training - Excell

ResolvedVersion Standard

Tue 14 Aug 2007, 12:53 Delegate Emma said...

Emma has attended:
Excel Intermediate course

Excell

how do i pull a pie chart apart and tilt it slightly?

Wed 15 Aug 2007, 06:30 Trainer Tracy said...

RE: Excell

Hiya Emma,

Thanks for the question.

To pull a pie chart apart you just need to click first on the whole of the pie chart, then on the sections. Once you see the sections have the black square handles around them you can drag them away from the rest fo the pie chart.

To be able to tilt a 3D pie chart you need to go into the chart menu and down to 3D View, there a graphic will appear that you can move.

Hope this helps

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

microsoft.excel.training - Excell

Excell

RE: Excell

Excel articles

Excel tip:

Generating Random Numbers