![]() This allows you to apply data labels showing bubble sizes to all the series on the plot or to just one selected data point. Note The Data Labels tab also appears on the Format Plot and Format Data Point dialogs. In the Type frame, select Show Bubble Sizes.Select the Format Series option from the context menu.To display data labels showing bubble sizes on a bubble chart series: Click Apply to see your changes or OK to accept your changes.Ī special data label formatting option for bubble charts allows you to display the bubble sizes in data labels.In the Bubble frame, enter a value from 0 to 300, representing a percentage of the default bubble size.Select the Format Plot option from the context menu.To change the relative sizes of all the bubbles on the chart: You can increase or decrease this default size to increase or decrease the size of all of the bubbles on the chart. To set the starting point for sizing bubbles, Formula One for Java uses an internally computed default size. Finish formatting the chart using the context menu options.įormula One for Java sizes the bubbles proportionally.Click Apply to view your changes or OK to accept your changes.For a bubble chart with more than one series, repeat step 6 for each series on the chart.Here is how the Chart Data tab was filled in for the example chart. (These range references should include only numeric data, not heading or other text cells.)įor more information about options for filling in the Chart Data tab, see Changing the Chart's Data Source. You can enter the text of the name or a cell reference pointing to the cell that contains the name.įill in the X Values, Y Values, and Sizes text boxes with range references that refer to the appropriate ranges on the worksheet. Fill in the Name text box with the name you want to appear for this color of bubble on the chart legend. ![]() ![]() For a bubble chart like the one in the example, which has only one color of bubble and therefore only one series, delete all but one series by selecting unwanted series and clicking the Delete button.The Chart Data tab of the Format Object dialog will appear. CTRL + click on the chart to select it, then choose Format > Object.The chart that appears will probably look odd, but you will fix it in the next steps. Change the chart type to Bubble, as explained in Changing the Chart Type.For more information, see Creating a Chart. (Since you will later define which cells should represent which areas, it doesn't matter which cells you select.) Click on the Chart button and draw the chart onto the worksheet. To create the chart, select the cells in the chart's data range. ![]() This is how the worksheet was set up for the example chart. You can set up your data range in any arrangement, even with non-contiguous cells.
0 Comments
Leave a Reply. |