Excel Bubble Chart Custom Shapes

Bubble charts are such attractive chart types to show complex data. When we use different bubble sizes, and different bubble colors to show patterns in a scatter diagram, we call that chart a bubble chart. Creating a bubble chart in an Excel sheet is not as complex as you think. Using Excel, we can create a beautiful bubble chart as below.

To create a bubble chart like the one above, do the following 1. Create a simple bubble chart. 1.1. Select the data range. The selected data range should contain The first column - the data for the horizontal axis Series X values, The second column - the data for the vertical axis Series Y values,

On the Insert tab, in the Charts group, click the arrow next to Scatter Charts.. Select the bubble with the 3-D effect icon. Click the chart area of the chart. This displays the Chart Tools.. Under Chart Tools, on the Design tab, in the Chart Styles group, click the chart style that you want to use.. If you see a legend on the chart, click the legend, and then press DELETE.

The following are some advantages of using the Bubble Charts in Excel A Bubble Chart can be used or plotted for three-dimensional data sets. A Bubble Chart representation is a lot better than the data in table format. The different sizes and colours of the Bubble Chart catch others' attention and looks visually attractive.

Bubble Charts in Microsoft Excel. Bubble charts are one way to show three dimensions of data in a flat 2D chart. In addition to the points being located on a grid according to X and Y values, the size of the marker is proportional to a third set of values. You can use the technique described in Custom Chart Series Markers to use any shape

Creating a Bubble Chart in Excel Step-by-Step Instructions. Creating a bubble chart in Excel is straightforward. Here's a step-by-step guide STEP 1 Make sure your data is organized in three columns. For instance, let's say you have data for different people with corresponding values for their age, weight and height.

1. Creating a Bubble Chart. Go to the Insert tab in Excel. Click on Insert Scatter X, Y or Bubble Chart. Choose either Bubble or 3-D Bubble. A blank chart will be created. Right-click on the blank chart and choose Select Data. Click on Add to add series data. Choose a Series name. Select the appropriate X and Y values e.g., C5C9 for X and D5D9 for Y.

The following labels will automatically be added to the bubble chart Step 4 Customize the Bubble Chart. Lastly, feel free to click on individual elements of the chart to add a title, add axis labels, modify label font size, and remove gridlines The final bubble chart is easy to read and we know exactly which bubbles represent which players.

Yes you can change the shape. To do so you need to use a custom marker. Create a shape using the autoshapes menu. Format the shape in terms of colour and border. Copy the shape using CTRLC. Select the data series in the bubble chart you want to change. CTRLV to paste the shape. Here is an explanation using pie charts as the custom marker but you

Next on the list, formatting axes to change the shape of the chart. Double-click on the axis that you want to format. We are starting with the vertical axis. Just like the Bubble chart, Excel offers a wide variety of other charts, tools, and functions. If you are on the journey to master Excel, you must not miss out on Excel functions.