12/13/2023 0 Comments Thought bubble chartIn the Insert Chart window, go to All Charts → X Y (Scatter) chart → Bubble Chart, and select the required chart from the given options.Ĭlick OK to close the window, and the below chart appears. And follow the path Insert → Recommended Charts to open the Insert Chart window. ![]() Step 1: Click a cell in the above table, or select the entire table range.The steps to create the Bubble Chart in Excel for the above data are, We will visually review the total revenue generated from the different ad categories. The table below shows different ad categories, the number of ads created, the cost per ad, and the total revenue generated from each ad category. We will see an example of the Bubble Chart in Excel with labels and bubbles in distinct colors. We will see how to apply such features in the Excel Bubble Chart examples explained in the next section.Ĭheck out the following Bubble Chart in Excel examples to use the plot in different scenarios. Thus, the required Bubble Chart will be as follows: Adding data labels and changing the bubble colors will help interpret the plot easily. Double-click the chart title and axis titles elements in the chart area, one at a time, to update them.Click the chart area to enable the Chart Elements option (‘+’ icon), and check the Axis Titles and Legend boxes.Click OK to close the Select Data Source window. Update the Series name field to achieve a profit-rate based Bubble Chart Excel 3 variables. In the Select Data Source window, select the Profit in $ option in the Legend Entries field, and click Edit. Therefore, to modify and obtain the required Bubble graph, click the chart area to enable the Design tab, and click Select Data from the Design tab to access the Select Data Source window. The above Bubble Chart in the worksheet is profit-based, and we require a profit rate-based plot.Click OK to close the window, and the below chart appears in the current worksheet. In the Insert Chart window, click X Y (Scatter) chart category in the “ All Charts” tab. Click on a cell in the above table, or select the entire table, and select Insert → Recommended Charts to open the Insert Chart window.And then click OK to complete the action. ![]() Click the “ All Charts” tab → select X Y (Scatter) chart → select Bubble Chart and the appropriate chart under it. The Change Chart Type window → All Charts tab will open. Select the required data range to plot, and press Alt + F1 to insert a default chart.īut, as we require the Bubble Chart, click the Design tab → select the Change Chart Type option. But once we update the selected data using Select Data in the Design tab while applying the alternative Insert tab option, the two charts will appear identical. The charts we obtain using the two options in the Insert tab might appear slightly different. Once we click the required Bubble Chart, the following graph will get inserted into our active worksheet.] Then, select the “ Bubble” option from the “Bubble” category. [Alternatively, we can select the required data range to plot → select the “ Insert” tab → go to the “Charts” group → click the “ Scatter (X, Y) or Bubble Chart” drop-down, as shown below. Select the required data range to plot → select the Insert tab → click the Recommended Charts option.Ĭlick the “ All Charts” tab → select the “ X Y (Scatter)” chart → select any of the “ Bubble Chart” chart type → click “ OK” to complete the action. We can create the Bubble Chart in Excel in 2 ways, namely, Since the above Bubble Chart is market share based, the bubble representing Product 3 is the biggest, indicating that its market share is the highest among the five products. On the other hand, Product 1’s bubble is the smallest in size, which indicates that it has the least market share, even though the units of Product 1 sold exceeded that of Product 3. To review each product’s market share visually, select cell range A1:D6, then, the generated Bubble Chart is shown below.Īs per the given data, Product 5 is the top-selling item, with the maximum number of units sold. ![]() Users can use the Bubble Chart to visually highlight numbers given in a financial dataset as bubbles of different sizes based on their values.įor example, the table below shows a list of products, units sold, prices, and market share data. And while the X and Y axes are value-based, the plot uses another value-based axis (Z) to represent the sizes, which enhances the plot’s data comparison capabilities. It represents data points as bubbles, with an added dimension of the given values denoted by the size of the bubbles. The Bubble Chart in Excel is a form of the Scatter plot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |