Skip to main content
Skip to main content
Microsoft 365

Can’t find the Chart Wizard? No worries

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. 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’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.

At first glance, it may seem that you are left with just a bunch of chart type buttons on the Insert tab of the ribbon. Not true. These buttons are just the starting point.

It’s a bit of a shift, but once you get used to the ribbon, it’s really quite simple. You may actually appreciate the fact that you’ll have many more options available at your fingertips.
When you click anywhere in your chart, you’ll notice that the Chart Tools are added to the ribbon. You’ll get three additional tabs that provide an assortment of chart design, layout and formatting options.

 You may want to take a few moments to explore the available options. In the Data group on the Design tab, for example, you’ll see that you can still switch data series over the axis the same way you could on step 2 of the Chart Wizard.

This table shows you where you’ll find all of the options you used in the Chart Wizard:

I especially like the predefined chart layouts and chart styles on the Design tab that provide instant professional results. On the Layout tab, I can add all sorts of chart elements or change the way they are displayed in the chart. It’s all there (and then some), trust me! Living up to its name, the Format 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’s not really that useful, but once you get the hang of it, I know that you’ll be proud to show off your professional-looking results.

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 dialog box when you right-click any chart axis). I’m a habitual right-clicker, because it’s 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: ”That’s just too easy!”

For more information on creating charts in Excel 2010, check out the article “Create a chart from start to finish.”  And check out the blog post on our eight best tutorials on Excel charts.

–Frederique Klitgaard, writer for Office.com

More info on Excel charts:

Combining Chart Types, Adding a Second Axis

Create a chart from start to finish

Free training: Take the next steps in growing your Excel skills (Lesson 2)

Go beyond the basic chart type

Use sparklines to show data trends

Line or scatter chart?

Format column sparkline charts using the date axis and cell merging

You may also like these articles

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…