![]() Use these to edit the Chart Elements, Styles, or Filters.Ĭhart Elements: Adjust the titles, labels, gridlines, legend, and trendline.Ĭhart Styles: Choose a different chart style or color scheme.Ĭhart Filters: Filter the data to display using values or names. You can then select the chart to drag it to a new spot or drag from a corner to resize it.Īlso, with the chart selected, you’ll see a few buttons display to the right. ![]() When you see the chart you want to use, click to insert it into your spreadsheet. If you’re using Excel on Windows, you can put your cursor over the various scatter chart types to see a brief description as well as a preview of the chart. Go to the Insert tab and click Insert Scatter or Bubble Chart in the Charts section of the ribbon. ![]() ![]() But you can change the title for the chart either way. By default, the chart title will be the header for your y-axis column. If you have column headers that you want to include, you can select those as well. If you have your data sets and want to see if a scatter plot is the best way to present them, it takes only a few clicks to make the chart. While similar to scatter charts, bubble charts use an additional number field to determine the sizes of the data points. You’ll also notice in the Scatter Chart menu options for bubble and 3-D bubble charts.
0 Comments
Leave a Reply. |