STEP 2: Go to Insert > Insert Scatter Chart or Bubble Chart > 3D Bubble. Using this data, let’s try to create a 3D Bubble Chart with 3 variables! In this data table, you have project-wise data including cost, profit, and probability of success. STEP 5: Under Axis Options > Minimum >Set the value to 0. STEP 4: Right Click on the axis and select Format Axis to open the Format Axis Panel. Formatting this axis to restrict negatives value is a good idea to avoid confusion. Since X-axis represents the age of the house, it cannot be negative. The horizontal axis contains negative values as well. STEP 3: Click on Series1 and Click Delete to remove it. STEP 2: Go to Insert > Insert Scatter Chart or Bubble Chart > Bubble. STEP 1: Select the table on where we want to create the chart. So, using Bubble Chart with 3 variables, you can plot the age of the house on the X-axis, the proximity to the city is on the Y-axis and the value of the house (the 3rd variable) as the size of the bubble.įollow the steps below to understand how to create a bubble chart with 3 variables: In the table, you have the age of the house, proximity to the city (in km) and the value of the house.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |