Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
3D charts provide additional formatting options so let's explore some of them using our Energy Saving Plan spreadsheet. Currently, we have two 2-Dimensional charts on this sheet, but we'll start by converting a 2D chart to a 3D chart. First, we'll select our Column chart called Costs by Month. One click will select it. Now to convert this to a 3D chart, let's use our Format Bar. We'll click the first button currently showing Column as the Chart Type and down at the bottom we find our 3D options including a 3D version of our column. Let's select that.
Instantly, you see changes being made to our chart. The viewing angle has changed, we might want to adjust the size to make a little bit easier to read some of the data for example. So let's start by using the handle at the very top center, when we see the double arrow, we'll click-and-drag upwards to increase the height of our chart. We'll also drag the handle at the bottom center down to increase our height even more. Now it's a little bit easier to read some of the numbers and to decipher the values for each of the columns in our chart. The other thing that happens by default is we see our Rotation Ball that appears. It allows us to change our viewing angle. We can change the viewing angle left to right, or up and down.
Let's start with left to right. Anywhere on the arrow is pointing left and right, click and then drag. We'll drag to the right to change our viewing angle slightly to the right. When we reach a certain point, you will notice the labels for our Y-axis switch from the right side over to the left. That's all automatic. We can also adjust our viewing angle up and down using the arrow pointing up and down. Click and then drag to change the angle in any direction. Just drag that upwards a little bit, so it's little bit easier to read the values using those columns.
When you are done changing your viewing angle, you can close this button and access some additional options through the Chart Inspector. Click the Inspector button and make sure the Chart Inspector is selected with the Chart button selected. Notice you have also got your 3D Scene options down below, including Lighting Style, which is currently set to the Default. But let's click this button to see, there are a number of other options to choose from such as Soft Fill or let's switch it to Glossy, which is a brighter option. We can also adjust the Depth of our chart. Currently, you can see the slider has it's buttoned towards the left side, we can drag this to the right to increase the depth, more back towards the left to decrease the depth and when you are done, release and close the Chart Inspector.
We will deselect our chart clicking the canvas anywhere, and that looks pretty good. Let's scroll down now towards the bottom where we see a 2-dimensional pie chart. Let's select it first by clicking once and go back to our Chart Inspector. Before we convert this to the 3- dimensions, notice down below we have options for exploding Wedges and changing the Rotation Angle. Let's rotate this a little bit so that our green slice is at the very top, at about 146 degrees. If we want to explode all the pieces, we don't select an individual slice.
If you want to explode a single slice, for example if we want to single-out our blue slice for the year 2007, we click once to select the slice and then we can click-and-drag our Explode slider to the right to pull it away from the other pieces. Let's do about 17%. You can see a Shadow has been applied to the individual pieces of our chart. That's what's been set up already for this particular chart, but we can change that to the entire group or choose no shadow at all. Let's select None and that's for our individual slice now and let's convert this entire chart now to 3-dimensions, a 3D pie chart.
First, we'll make sure that the entire chart is selected. This is our Total Costs by Year chart. You can select it from the Sheets pane. And now we can use our Chart Inspector to change the Chart Type. The current type appears at the top, a 2-dimensional pie. Remember the 3D options are on the right-hand side using this option. So let's go down to our 3D pie and select. And notice our Wedge is still is exploded out and we have now got a 3D version of our pie chart. So we might want to use the 3D Scene section that now appears to adjust our viewing angle for example. Drag up and down, left to right, until you achieve the desired angle.
And again, we can adjust our Chart Depth as well and change the Lighting Style. Let's have it match our Column chart at the top, we'll select Glossy. So this makes it difficult to read some of the labels. So maybe we should go back to Soft Light. That's a little bit better and with a pie chart, we can also choose to show Bevels. So this can really enhance the edges of our pie chart. When we use our bevels, we can see the separators a little more clearly and when we are done, close the Chart Inspector and deselect by clicking the canvas.
So remember when using 3D versions of your charts, you have got those additional 3D formatting options to enhance the look and feel of your charts.
There are currently no FAQs about Numbers '09 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.