Changing Your Chart Type

Once you’ve created a chart, you can change chart type at any time without losing the data. For instance, you can quickly change from a bar-chart to a pie-chart if you think it will display the information more clearly.

First, select your chart to access the chart options heading, and then select the Design tab.  Now select the change chart button at the left hand side of the ribbon:

Now you can choose from a range of chart templates, including column, bar, scatter and line charts. You can also set one particular type to become the default chart template that will appear when you create a chart.

In this example, select a 3-D cone chart for the following result:

Similar resources you may like

1. Creating charts
2. Altering and Moving your chart
3. Moving a Chart To a Chart Sheet
4. Changing Your Chart Layout
5. Changing Your Chart Style

Tags

Excel, excel training, excel training sussex, excel tutorial, Free, microsoft, microsoft excel, Microsoft Office, resource, sussex, Tips, top Tips, Training

Share This Resource

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine