It has affected our chart, but do not fear, that is only temporary and it will even look worse on the next step. The purple “Series4” is the series that we just added. Your chart will now look like this: Radar Chart with New Special Pasted Series 4) Move New Series to 2nd Axis Then choose “New Series” and “Columns” radio buttons and also the “Categories (X Labels) in First Column” check box and press okay. Or select the chart and then press ALT+E+S to bring up the Paste Special for Chart dialog box. Then select the Chart and select Paste Special from the Hom Riboon > Paste options. First Select the new series data range A8:B18: Radar Chart -Alternate Data Range for Vertical Axis Selection You can add a series to your chart in several ways. 3) Copy / Paste Alternate Data Range for Vertical Axis as Special as Columns This will become more apparent in the 4th step below. So 5×2+1=11 categories for our bar chart. In this tutorial, the largest value is 5, so that means that I will need 5 text values from 1-5 and one for zero and then the repeating 5 below the zero value will be blank.
This will make sure the vertical text and numbers will line up. There is a rule that you should determine the largest value of your radar chart, double that value and add one.
If you found the website and tutorials helpful, please consider donating to keep the lights on. Radar Chart -Alternate Data Range for Vertical Axis The values in B8:B18 are just place holders and we will remove or zero out these values before we complete the chart. But you will notice that I have added values in the column to the right (cells B8:B18) as we will need this range for a future step of creating a Clustered Bar Chart. You will see those values in cells A8:A13 below. To create this fake, you will have to create you Text Labels for the vertical axis. To create the Excel Radar Chart Axis with text, we need to fake Excel by adding another series to the chart. Your chart will now look like this: Replace Numbers with Text Radar Chart Axis Values-Initial Chart 2) Create Alternate Data Range for Vertical Axis Radar Chart Axis Values-Insert Radar Chart TO create the radar chart, select that range and then go to the Insert Ribbon and select Other Charts and then choose the Radar Chart option. For this tutorial, we will have our initial radar chart data in cells A1:D6.
0 kommentar(er)
