Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can change a chart's type at anytime. Just keep in mind that some chart types use row and column data from a table differently than others. To change the chart type in our Running Club Data spreadsheet, let's first select the chart. Notice down below on our sheet, we can see that various columns from different tables are being used to display our data. To change the chart type, we can use the Format bar. The first button in the left-hand corner displays the current chart type as Mixed. Click this button to see a list of all the other chart types we can select. Let's choose Column.
When we choose Column, we see the same data displayed differently. Whenever we switch to a Bar column area or even Line chart, each series in the new chart corresponds to a row or column in our case, the three columns highlighted in our tables. Now let's try switching to a different type of chart, a Pie Chart. We can do this by a right clicking or Ctrl- clicking the selected chart. Now from the pop-up menu move to Chart Type, and let's choose Pie. Now whenever you switch to a Pie Chart the first data point in each series is represented as a wedge, and this isn't the best choice for our set of data.
So let's try one more, this time from the Chart Inspector. With our chart selected, click the Inspector button and make sure that the Chart Inspector is selected. You will see the chart type in the top-left corner. We can click this button to display the various chart types we can choose from. This time let's choose a 3D version of our column. When you switch to a 3D version of a chart, the Chart Inspector provides a number of controls for managing object Depth, Lighting Style and so on. Now when you change a charts type and the new type has some of the same attributes, those attributes don't change. Some of those shared attributes include the axis that we see down across the bottom of our chart, and up the right-hand side. Also some other shared attributes include the axis labels, any borders or rotation, shadows, and even 3D lighting that's been applied to our 3D Chart. Let's deselect the chart to see the end result.
So changing a chart's type is a simple undertaking but not all charts display data the same way. Select similar chart types when you want to maintain the same result.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91299 Viewers
80 Video lessons · 138229 Viewers
59 Video lessons · 57053 Viewers
52 Video lessons · 70713 Viewers
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.