Excel Tip of the Day
Change an existing Excel chart to a different type (97/2000/2001/2002)
After you create a chart, you may wonder how the same set of data would appear as a different chart type. For instance, you may start with a column chart, but then think that a line chart might present the data better. In such cases, you don't have to start from scratch with a new chart. You can simply change your existing chart to a different chart type using a number of different techniques:
- The Chart Wizard -
Select the chart object and then click the Chart Wizard button on the Standard toolbar. Doing so displays the first screen of the Chart Wizard, allowing you to pick a different chart type, as well as make any other changes you normally can with the wizard. Select the chart type you want to use and click OK.
- The Menu Bar -
Select the chart object and then choose Chart | Chart Type from the menu bar. This displays the Chart Type dialog box, which is essentially the same as the Chart Wizard's first screen. Select the chart type you want to use and click OK.
- The Chart Toolbar -
Select the chart object. If the Chart toolbar doesn't automatically appear, choose View | Toolbars | Chart from the menu bar. This toolbar contains a Chart Type toolbar button, which has a small dropdown arrow associated with it. Click on the arrow to reveal a palette of 18 commonly used chart types. Simply select the chart type you want to use and the current chart is automatically reconfigured.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2026 MJ Technologies, LLC. All rights reserved.