Software

10 cool new charting features in Excel 2013

Excel 2013 includes a healthy assortment of new charting features that will save you a lot of time and help you produce better results.

Excel 2013 charts can be completed in a few minutes. Charts that used to require specialized knowledge and a lot of time and experimentation have been reduced to a few clicks. The emphasis is on generating quick and appropriate charts, from the get-go. Once you have figured out the best chart type, Excel 2013 offers new interactive options for tweaking your chart until it's perfect.

We'll step through 10 of Excel 2013's new charting features, updating a chart as we go. In the end, there's no guarantee you'll like the results. But what I can promise is that you won't spend much time creating new charts once you're familiar with these new features. You'll generate charts much quicker and spend less time regretting choices -- it's just too easy to undo them and start over!

1: Recommended Charts

Choosing the appropriate chart type to represent your data's story and applying that choice requires knowledge (sometimes experience) that many users don't have. Recommended Charts takes a bit of the pain out of this process. To use this new intuitive feature, click inside the data range you want to chart, click the Insert tab, and click Recommended Charts. Excel will display a thumbnail collection of suggested chart types, as shown in Figure A. You can click each one to preview your data presented in that chart type. Figure B shows the data as a stacked column chart -- the second choice for charting the data. Going this route helps you quickly zero in on the right chart type for your data. Double-click your choice to embed it.

Figure A

Figure A

Use Recommended Charts for a quick start on generating effective charts.

Figure B

Figure B

Choosing the right chart is as simple as a double-click.

This new feature is so smart that you'll want to check it out even if you're a charting expert. At the very least, it will save you time by starting with the most appropriate charts, which you can then tweak as necessary.

2: Better organization

Earlier versions of Excel offered three contextual tabs for working with charts. Figure C shows the two new contextual charting Ribbon tabs in Excel 2013: Design and Format. The Layout tab from the earlier Ribbon versions is missing. That seems like a bad thing, but it isn't—the options are better organized so finding them is easier.

Figure C

Figure C

Many charting options are on these two tabs.

3: Chart Elements

The new Chart Elements icon, shown in Figure D, replaces the Layout tab from earlier versions (#2). This new interface tool is probably the most versatile -- the one you'll turn to the most often. To use this icon, just click it. Then, check or uncheck the chart element you want to add or delete, respectively. Figure E shows the result of removing the gridlines and adding an axis title.

Figure D

Figure D

Use these icons for quick access to charting options that were layers deep in earlier versions.

Figure E

Figure E

Quickly add and remove chart elements to customize your chart. 4: Chart Styles

The Chart Styles icon will help you change the way a chart looks by applying predefined styles. They've always been available, but you had to manually combine the different formats to get the final product. Now, they're available with a quick click. Figure F shows the new Chart Styles list and the result of applying one of the styles -- that's a lot of change for a simple click. (Okay, so it isn't perfect; but that gives an opportunity to explore quick fixes!)

Figure F

Figure F

Apply a predefined style to reduce your formatting chores.

5: Chart Filters

The last icon, Chart Filters, lets you quickly add and remove values. In this case, it makes sense to remove the totaling rows and columns. To do so, click the Chart Filters icon and start unchecking items from the list shown in Figure G. Figure H shows the resulting chart after removing the Totals and Commissions values.

Figure G

Figure G

Use the filters list to quickly remove (or add) a series.

Figure H

Figure H

Removing the totaling values took just a few clicks.

6: Flexible data labels

Data labels are more manageable now because Excel 2013 offers more formatting and shape options. One clever option lets you easily connect them using a leader line. To see all the new possibilities, select a data label and click Chart Elements. Then, click the drop-down to the right of Data Labels and choose More Options, as shown in Figure I. (Applying a predefined style in #4 automatically added data labels to the example chart. To manually add data labels, click the Chart Elements icon and check Data Labels.) Figure J shows the options pane where I changed the format used to display the data labels' values. Specifically, I reduced the number of values and added the M character to represent millions. You can even use freeform text and anchor a label to a specific cell now.

Figure I

Figure I

Quick access and new options makes managing data labels easier than ever.

Figure J

Figure J

With just a few clicks you can reformat the values.

To learn more about the custom format used in this example, read Use a custom format in Excel to display easier to read millions.

7: Formatting task pane

For quick and easy access to an element's properties, double-click it; Excel will display that element's properties in the Formatting task pane. Figure K shows options for the chart's legend. Use the element selector (circled) to gain quick access to other elements, especially those small, hard-to-select elements.

Figure K

Figure K
Every element's formatting options are just a double-click away.

8: Combo charts

Combo charts require specialized knowledge in older versions. Now, they're a simple choice. After selecting your data and choosing Insert Chart, click the All Charts tab and select Combo.

We can work with our example chart, but first it needs a series that warrants a combo chart. Figure L shows a modified data range. I added a column of MAX() functions to return the largest value in each region. To add the new values to the chart, do the following:

  1. Select F2:F6 and press [Ctrl]+C to copy the new values to the Clipboard.
  2. Select the chart and press [Ctrl]+V to add the values to the chart as a new series. (You've always been able to add a new series this way.)

Figure L

Figure L

Add a new series to the chart.

Now, you can create a combo chart using the new values in column F, as follows:

  1. Select the chart, if necessary, click the contextual Design tab, and click Change Chart Type in the Type group.
  2. Click the All Charts tab and choose Combo.
  3. In the bottom pane, you'll probably have to reset the chart type for each series from clustered column to stacked column using the Chart Type drop-down for each series.
  4. Using the Chart Type drop-down for the Max series, choose Line (if necessary), as shown in Figure M.
  5. Click OK to see the combo chart in Figure N.

Figure M

Figure M

Select the appropriate type for each series.

Figure N

Figure N

This chart displays the totals as a line.

9: More dynamic data labels

 The example looks a bit cluttered with all those data labels, so it's time to rethink the chart's purpose. (Aren't you glad that you didn't spend a lot of time adding them?) Let's suppose that you want to emphasize the $10,000 loss for Michaels in the West region. To do so, delete all the data labels except for that one, as shown in Figure O, as follows:

  1. Your first step is to move the data label you want to keep. Select it -- not using a quick double-click, but two slow clicks. Doing so will select only that data label.
  2. Drag the single data label to the top of the plot area, out of the way.
  3. Select each series of data labels and press [Del]. When you come to the series that contains the -$10,000 value, you'll have to select each individually (using two slow clicks) to delete them without deleting the data label for -$10,000.

Figure O

Figure O

Retain only one data label for emphasis.

At this point, you can't read the label, so reformat it by double-clicking it and changing the font color to black as follows:

  1. Click the Fill & Line icon (top of the Format task pane).
  2. Change the label's font color. Perhaps the quickest way is to simply select it as you would any text and use the Font Color tool on the Home tab (in the Font group).

To truly emphasize your point, add some meaningful text. Position the cursor inside the data label and start typing. Figure P shows the addition of a simple but effective message. This technique isn't exactly new and renders your label static. If you change the value in cell D6, the label won't update accordingly.

Figure P

Figure P

Make a specific point using text.

There's a fix for that now. Position the cursor in the data label where you want the value to appear, right-click, and do the following:

  1. Choose Insert Data Label Field, as shown in Figure Q.
  2. In the resulting dialog, select [Cell] Choose Cell, as shown in Figure R.
  3. Identify the cell that contains the value (D6) and click OK.
  4. At this point, you'll have the previously formatted value and the formatted cell value. Delete the previously formatted value (in the data label) and keep the new one, because that field is now linked to the cell D6. After linking the data field to the cell, you can update the source value and the data label will also update – automatically. The data label isn't dynamic; the data field inside the data label is dynamic (Figure S).

Figure Q

Figure Q

Right-click the data label to make the value dynamic.

Figure R

Figure R

Link to the source cell.

Figure S

Figure S

The data field in the lone data label is dynamic.

At this point, the chart looks pretty good. It isn't finished -- you might want to check out a few more predefined styles and add a chart title (we never did that, but that's nothing new). The stacked bars for the West region present an interesting problem, as there's little distinction between the personnel. But depending on your point of view, that might be exactly the look you need. Producing this chart took no specialized knowledge other than knowing how to find options via the new interface features.

10: Quick Analysis charts

Quick Analysis offers a second easy route to quick charts that are appropriate for the data. Simply select the data and click the Quick Analysis icon at the bottom-right, as shown in Figure T. Click the Charts tab to view the most appropriate chart types for your data. If you don't see the Quick Analysis icon, check your settings as follows:

  1. Click the File tab and choose Options from the left pane.
  2. Choose General in the left pane (the default).
  3. In the User Interface Options section, the Show Quick Analysis Options On Selection option should be checked. Enabled is the default, so you should see this icon unless someone has changed this setting.
  4. Click OK.

Figure T

Figure T

Use Quick Analysis to generate appropriate charts quickly.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

182 comments
abbasishariq2
abbasishariq2

Stretch Tents for hire and rental,nomadic stretch tents rent, bedouin tents, event flooring, manufacturing and marquee sales in Johannesburg. Stretch Tents for hire and rental,nomadic stretch tents rent, bedouin tents, event flooring, manufacturing and marquee sales in South Africa. Event Flooring Rental

ljenni99
ljenni99

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article..!! voyance carte

abbasishariq2
abbasishariq2

Tennessee DUI LawyerSuch bathrooms can still be enhanced by providing better finishes such as sanitary fittings of a higher quality, apart from its layout, noted Mr Francis Koh, group chief executive of Koh Brothers Group.

abbasishariq2
abbasishariq2

There animator that may be obtained very easily. But, essentially, all your animators possess the capacity and also ability connected with different. warehouse for sale

abbasishariq2
abbasishariq2

Winrar Free Download

We believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.

abbasishariq2
abbasishariq2

I am always searching online for articles that can help me. There is obviously a lot to know about this. I think you made some good points in Features also.

hotmail
abbasishariq2
abbasishariq2

Best Facials in ManhattanYou have a real ability for writing unique content. I like how you think and the way you represent your views in this article. I agree with your way of thinking.


abbasishariq2
abbasishariq2

Waxing Center ManhattanWe believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.

abbasishariq2
abbasishariq2

Very exciting to study this content.I would like to thank you for the initiatives you had created for composing this amazing content. friv 2

abbasishariq2
abbasishariq2

A simple bookmarking tool that makes it easy to save, organize and share your favorite web pages. Access your bookmarks from any computer, phone or tablet. Listango works on all modern web browsers…Trucking Jobs

abbasishariq2
abbasishariq2

This content is written very well. Your use of formatting when making your points makes your observations very clear and easy to understand. Thank you!amazing selling machine

abbasishariq2
abbasishariq2

A simple bookmarking tool that makes it easy to save, organize and share your favorite web pages. Access your bookmarks from any computer, phone or tablet. Listango works on all modern web browsers…

 insurance quotes comparison

abbasishariq2
abbasishariq2

 don’t know what has happened to the custom of delivering consistent good articles. I hope that the custom comes alive after this..thumbs up for your work. Not Guilty

abbasishariq2
abbasishariq2

van hire londonWe believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.

abbasishariq2
abbasishariq2

Nottingham Digs

Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog.

abbasishariq2
abbasishariq2

Best women training shoesYou will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.

abbasishariq2
abbasishariq2

Search and Apply for the latest jobs in the Aviation, Aerospace and Airline industry. Including Pilots,Cabin Crew and Engineers Jobs from the world's leading Employers.


Aviation Jobs
abbasishariq2
abbasishariq2

flat shoes

We believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.
abbasishariq2
abbasishariq2

We believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventionsManhattan spa Gift certificates

abbasishariq2
abbasishariq2

Mspy Sign in I have to voice my passion for your sharpness in writing and giving acknowledges to people. The post should have magnificent guidance on this important matter.

abbasishariq2
abbasishariq2

WebsiteBuilder

Really great post, Thank you for sharing This knowledge.Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Please keep it up

abbasishariq2
abbasishariq2

Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing.Best Webhosting

abbasishariq2
abbasishariq2

chat with strangersSuch bathrooms can still be enhanced by providing better finishes such as sanitary fittings of a higher quality, apart from its layout, noted Mr Francis Koh, group chief executive of Koh Brothers Group. 

abbasishariq2
abbasishariq2

such an interesting article here Afatogel.com Bandar TerbesarSitusTogel Online Terpercaya. I was searching for something like that for quite a long time and at last I have found it here.how to start a blog

abbasishariq2
abbasishariq2

harga laptop bekasWe believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.

abbasishariq2
abbasishariq2

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.voyance directe

abbasishariq2
abbasishariq2

I want you to thank for your time of this wonderful read!!! I definately enjoy every little bit of it and I have you bookmarked to check out new stuff of your blog a must read blog!!!!

MOBE

abbasishariq2
abbasishariq2

van hire london

It is great to have the opportunity to read a good quality article with useful information on topics that plenty are interested on.I concur with your conclusions and will eagerly look forward to your future updates.
abbasishariq2
abbasishariq2

Loft conversions London You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.

abbasishariq2
abbasishariq2

payday loans

Such bathrooms can still be enhanced by providing better finishes such as sanitary fittings of a higher quality, apart from its layout, noted Mr Francis Koh, group chief executive of Koh Brothers Group

abbasishariq2
abbasishariq2

Thanks for a wonderful share. Your article has importaciones your hard work and experience you have got in This field. Brilliant reading .I love it. seo company

abbasishariq2
abbasishariq2

An easy bookmarking instrument so that it is simple spends less, set up and also reveal your favorite WebPages. Accessibility your own social bookmarks by any kind of laptop or computer, cell phone as well as product. Listing is effective on all modern-day World Wide Web browsers…Personal Trainer Cheshire


abbasishariq2
abbasishariq2

really appreciate that you wrote this article and shared some really good information on this specific topic. I was in vital need to get some information on this topic and thanks to you, I've got that! Thanks, once again!

loft plan reviews

abbasishariq2
abbasishariq2

I really like the dear information you offer in your articles. I’m able to bookmark your site and show the kids check out up here generally. Im fairly positive theyre likely to be informed a great deal of new stuff here than anyone else ! How To Make Your Dick Bigger

abbasishariq2
abbasishariq2

Hello ! I just wish to give an enormous thumbs up for the nice info you’ve got right here on this post. I will probably be coming back to your weblog for more soon what to text your ex girlfriend to get her back.Visit this site

abbasishariq2
abbasishariq2

We believe that everyone deserves a chance at moving ahead with their lives. In our Mitigation services we strive to provide the Court with your history For our other court appointed services, our goal is to help provide the most up to date and relevant interventions.crowdfunding promotion

abbasishariq2
abbasishariq2

You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.Loft conversions London

abbasishariq2
abbasishariq2

I really liked the font you've chose to use in this article. Could I please get the name of that font? I wanted to use it in my project now. Thanks very much!

Waxing NYC

Editor's Picks