New Chart Formatting Tools in Excel 13

Have you ever gotten confused and lost when trying to format your Chart by using the Chart Tools tab in Excel?

Well don’t worry anymore because with the new version of Excel, we can fine tune our charts quickly and most importantly very easily. A few clicks are needed to change the Title, Layout and other chart elements.

Once a chart is created in Excel 13, and once it is selected, all we have to do is to select one of the three icons that appear at the top right corner of the chart as shown in the image below.

Selected Chart

Let’s see thoroughly what these chart formatting tools have to offer us:

1. Chart Elements

Once we select the first icon (plus sign), we have the control over the Chart Elements, such as Chart Title, Data Labels and Legend.

     a. Chart Title

We can define where we want the Chart Title to appear such as Above Chart, Centered Overlay and More Options. If we don’t want it to appear we must deselect the check box at the left of the command.

02

Once we select the More Options command, the task pane appears at the right of our window offering us many more options in order to Format the Chart Title. As we can see in the image, we can use either one of the following two tabs in order to format our chart title.

     *Title Options:

02a

     *Text Options:

02b

b. Data Labels

We can define where we want the labels to appear in our chart, such as Center, Inside End, Outside End, Best Fit, Data Callout and More Options. If we don’t want it to appear we must deselect the check box at the left of the command.

03

Once again if we select the More Options command the task pane appears at the right of our window offering us many more options in order to Format the Data Labels. As we can see in the image we can use either the Label Options tab or the Text Options tab, in order to format our data labels.

03a

c. Legend

We can define where we want the Legend to appear in our chart, such as Right, Top, Left, Bottom and More Options. If we don’t want it to appear we must deselect the check box at the left of the command.

04

If we select the More Options command the task pane appears at the right of our window offering us many more options in order to Format the Legend. As we can see in the image we can use either the Legend Options tab or the Text Options tab, in order to format our Legend.

04a

2. Style – Color

Once we select the second icon (brush), we have the control over the Style and Color of our chart. We can use the scroll down bar so we can select the most appropriate Style, Color of the Chart.

     a. Style

05

     b. Color

06

3. Values-Names

Once we select the third icon (filter), we have the control over the Values and Names of our chart.

     a. Values:

We can filter out the data of our chart by either deselecting or selecting the Series or Categories that we need. Once we have finished we press the Apply button which is located at the bottom left in order for the changes to be applied. We can also select the Select Data command, so we can select the Data that is needed for our chart all over again.

07

     b. Names:

We can define if we want the name of our Series or Categories to appear or not in our chart by selecting the corresponding buttons.

07a

Of course we can still use the commands that appear under the Chart Tools tab, and specifically the Design and Format tab as we can see below, but personally I prefer the Quick Formatting buttons that appear once the chart is selected.

08

Chart Tools

Below you can check out the video demonstrating how to format a Chart fast and easy using the new Chart Formatting Tools in Excel 13.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on October 14, 2012, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on New Chart Formatting Tools in Excel 13.

Comments are closed.