How to Create a 4 Axis Chart in Excel

Bar graphs and pie charts are fairly simple to produce and helpful for displaying number series. But when you need to express graphic representations of data that require more than three axes, you want a radar chart.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Some examples of data best represented by more than three axes are a comparison of the amount of rainfall in inches for each of all four seasons within a year, or comparing and displaying amounts of revenue for various products for each of four quarters. Going beyond these examples, there are many applications suitable for Microsoft Excel Radar charts.

Step

Create a new spreadsheet in Excel.

Step

Type the label names of your axes in each column, for example, Axis 01, Axis 02, Axis 03, and Axis 04 as headers in columns A, B, C, and D respectively.

Step

Type the corresponding data for each column and row. The row data will be the “Series” plotted against the actual axis of each column.

Step

Highlight the entire set of rows and columns by dragging the mouse cursor across the axis and data fields while holding the left mouse button down.

Step

Click “Insert," "Charts," then "Other Charts" and choose a "Radar" option from the main menu.