➤ The Series bubble size will be the selling price, cost price, and profit of the product Apple and then finally press OK. ➤ For Series X values select the serial numbers of the Additional Range 1 and then for Series Y values select the serial numbers in the three columns of Product Apple of the Additional Range 2. ➤ Click on the Add button to enter another series. In this way, we have added a new series Series 1. ➤ Series bubble size will be the selling price, cost price, and profit of the product Orange and then press OK. ➤ For Series X values select the serial numbers of the Additional Range 1 of the Bubble sheet and then for Series Y values select the serial numbers in the three columns of Product Orange of the Additional Range 2. ➤ After removing Series1 click on Add to include a new series. ➤ Select the already created series Series1 and click on Remove. ➤ Then choose the option Select Data from various options.Īfter that, the Select Data Source dialog box will open up. ➤ To rearrange the bubbles select the chart and right-click on it. ➤ Select the range of values ( C4:E8) and then go to the Insert Tab > Charts Group > Insert Scatter (X, Y) or Bubble Chart Dropdown > Bubble Option.Īfter that, the following Bubble chart will be created. In this step, we will insert a Bubble chart for the 3 sets of values and then rearrange the bubbles with the help of the two additional ranges. Step-02: Inserting Bubble Chart to Create a Matrix Chart in Excel Make sure that the serial numbers in these columns are arranged in reverse orders. ➤ For the Additional Range 2 after entering the product names in the first column, you have to add 3 extra columns (as we have 3 sets of values in the Selling Price, Cost Price, and Profit columns). ➤ In the Additional Range 1, you can add two columns one is containing the product names and the other is containing the serial number of the products. To create 5 different series for the 5 available products in the Bubble chart we will need 2 additional ranges. Step-01: Creating Additional New Data Ranges The selling prices, cost prices, and profits of the 5 products Orange, Apple, Kiwi, Walnut, and Raspberry will be arranged through the bubbles in this chart to visualize them easily. The procedures for creating a Matrix Bubble Chart will be discussed in the following steps of this section. Conclusion Type-01: Creating a Matrix Bubble Chart in Excel
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |