Creating Charts In Excel How To Create Two

Its useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey data.

Its likely youve run across them before, even if you didnt know thats what they were.

Creating Charts In Excel How To Create Two

In this article, well show you how to create two types of Radar Chart: a regular chart (like the one above) and a filled chart (like the one below, which fills in the areas instead of just showing the outlines).

Switch to the Insert tab and then click the Waterfall Chart button.

Choose the first Radar Chart option for this example.

The second option just adds markers to the values on the lines; the third option fills the chart, and well be looking at that one a bit later.).

Click the Chart Elements button at the top, and then hover your mouse over the Legend option.

Click that and then click the Right option on the menu that appears.

We want to edit the Minimum setting under the Bounds section, so click that field and type 3 there.

In our example, we want the range A1:A6 and the range D1:D6 as shown below.

To do this, hold the Ctrl key while you select each additional cell you want to add to your selection.

Instead, the minimum bound will be the lowest number in the range of cells you selected.

In our case, the minimum bound is 4.4one tick below Keiths minimum score.

So, for example, we would set the minimum bound to be a bit below the lowest ranking of any trainer and the maximum bound to be a bit higher than the highest ranking of any trainer.

You could even remove the axis itself to reduce clutter on the chart.

They can be a useful addition to your Excel reports in the future.

On most days, he can be found teaching Excel in a classroom or seminar.

Alan gets a buzz from helping people improve their productivity and working lives with Excel.

Since we launched in 2006, our articles have been read more than 1 billion times.

Creating Charts In Excel For Mac