With shortcuts, you can also see the effects of options on the fly before applying them. You can add/remove elements, apply predefined styles and color sets and filter values very quickly. In Excel 2013 and newer versions, charts also support shortcuts. For example, this option is labeled as F ormat Data Series… in the following image.

To display the side panel, choose the option that starts with Format.

Right-clicking an element will display the contextual menu, where you can modify basic element styling like colors, or you can activate the side panel for more options. The side panel contains element specific options, as well as other generic options like coloring and effects. Please keep in mind that you don’t need to double click another element to edit it once the side panel is open, the side menu will switch to the element. Double-Clickingĭouble-clicking on any item in the chart area pops up the side panel where you can find options for the selected element. You can customize pretty much every chart element and there are a few ways you can do this. Now, let’s take a look at some customization options. In this example, we’re going to be using Radar.Ĭlicking the icon inserts the default version of the chart. Go to the INSERT tab in the Ribbon and click on the Radar Chart icon to see the pie chart types. If you include data labels in your selection, Excel will automatically assign them to each column and generate the chart. Filled Radar: Puts more emphasize in the areas between chart lines.īegin by selecting your data in Excel.Radar with Markers: This type places markers on data points to make them easier to read.Radar: The default radar chart featuring straight lines.There are three types of commonly used radar charts. Legend: The legend is an indicator that helps distinguish the data series.Giving your chart a descriptive name will help your users easily understand the visualization. Plot Area: Where the visual representation of data takes place.

A radar chart mainly consists of three sections:

Cara membuat grafik di excel 2013