Going, going, gone! Yes, it\u2019s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn\u2019t bring it back in Excel 2010. For those of you upgrading from Excel 97-2003, this may come as a big shock. The Chart Wizard provided a useful four-step process that you could simply follow to create a chart with a finishing touch. Unfortunately, it didn\u2019t make sense to update the Chart Wizard to incorporate the many changes that were made when the chart engine was rebuilt for Excel 2007. Instead, the ribbon became the new place to go for all your charting needs.<\/p>\n
At first glance, it may seem that you are left with just a bunch of chart type buttons on the Insert<\/b> tab of the ribbon. Not true. These buttons are just the starting point.<\/p>\n
<\/p>\n
It\u2019s a bit of a shift, but once you get used to the ribbon, it\u2019s really quite simple. You may actually appreciate the fact that you\u2019ll have many more options available at your fingertips.
\nWhen you click anywhere in your chart, you\u2019ll notice that the Chart Tools<\/b> are added to the ribbon. You\u2019ll get three additional tabs that provide an assortment of chart design, layout and formatting options.<\/p>\n
<\/p>\n
You may want to take a few moments to explore the available options. In the Data<\/b> group on the Design<\/b> tab, for example, you\u2019ll see that you can still switch data series over the axis the same way you could on step 2 of the Chart Wizard.<\/p>\n
<\/p>\n
This table shows you where you\u2019ll find all of the options you used in the Chart Wizard:<\/p>\n
<\/p>\n
I especially like the predefined chart layouts and chart styles on the Design<\/b> tab that provide instant professional results. On the Layout<\/b> tab, I can add all sorts of chart elements or change the way they are displayed in the chart. It\u2019s all there (and then some), trust me! Living up to its name, the Format<\/b> tab provides many ways to format a chart using special effects that have never been available in earlier versions of Excel, such as the bevel effects shown in the chart below. It takes a bit of practice, and you may think it\u2019s not really that useful, but once you get the hang of it, I know that you\u2019ll be proud to show off your professional-looking results.<\/p>\n
<\/p>\n
I also want to point out that you can right-click on any chart element for quick access to specific features that can be applied to that element (for example, you can get to the Format Axis<\/b> dialog box when you right-click any chart axis). I\u2019m a habitual right-clicker, because it\u2019s a little faster than finding the options I need on the ribbon. And whenever I point this method out to my peers, this is their typical response: \u201dThat\u2019s just too easy!\u201d<\/p>\n
–Frederique Klitgaard, writer for Office.<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010.
\nFor those of you upgrading from Excel 97-2003, this may come as a big shock. The Chart Wizard provided a useful four-step process that you could simply follow to create a chart with a finishing touch. Unfortunately, it didn’t make sense to update the Chart Wizard to incorporate the many changes that were made when the chart engine was rebuilt for Excel 2007. Instead, the ribbon became the new place to go for all your charting needs.
\nKeep reading to learn how easy it is to create and work with charts in Excel 2010.<\/p>\n","protected":false},"author":76,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[],"class_list":["post-1072","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n