![how do i add a series to a scatter chart in excel how do i add a series to a scatter chart in excel](https://img.techwallacdn.com/375/ppds/f952b065-1877-4985-b672-0b6d212e4437.png)
Add data labels to the chart by checking the Data Labels option in the Chart Elements menu.ĥ. In the Format Data Series task pane, change the gap width to 50% by either typing 50 in the Gap Width box and pressing Enter on the keyboard or moving the slider to the left.Ĥ.Double-click on the bars to open the Format Data Series task pane.Note: If some subcategory labels are missing, increase the height of the chart until it shows all subcategory labels.ģ. This inserts a multi-category chart into the worksheet.
![how do i add a series to a scatter chart in excel how do i add a series to a scatter chart in excel](https://saylordotorg.github.io/text_how-to-use-microsoft-excel-v1.1/section_08/4bdfe868d26448a305eabff10fa6ffa4.jpg)
Select the data and on the Insert tab of the ribbon, in the Charts group, click on the Insert Bar Chart button and in the opened menu, click on the first option, which is Clustered Bar, among the 2-D Bar charts. The store’s products fall under 3 main categories: clothing, shoes and accessories.Ģ. For the purpose of this tutorial, suppose you have sales figures for different products of an online store for a month. Arrange the data in the following way: Enter main category names in the first column, subcategory names in the second column and the figure for each subcategory in the third column in the format shown below. To create a multi-category chart in Excel, take the following steps:ġ.
![how do i add a series to a scatter chart in excel how do i add a series to a scatter chart in excel](https://assets-us-01.kc-usercontent.com/cddce937-cf5a-003a-bfad-78b8fc29ea3f/3605ded0-a92e-485e-9699-6fd97503cc6a/Scatter_and_Bubble.png)
If you prefer written instructions, then continue reading.
How do i add a series to a scatter chart in excel how to#
Watch the video below to see how to create a multi-category chart in Excel. In other Excel versions, there may be some slight differences in the described steps. This type of chart is useful when you have figures for items that belong to different categories. On the Layout tab, in the Analysis group, do one of the following:Ĭlick Lines, and then click the line type that you want.Multi-category chart or multi-level category chart is a chart type that has both main category and subcategory labels. This displays the Chart Tools, adding the Design, Layout, and Format tabs. By default, these bars are also added to stock charts, such as Open-High-Low-Close and Volume-Open-High-Low-Close.Ĭlick the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stock chart to which you want to add lines or bars. Up-down bars Useful in line charts with multiple data series, up-down bars indicate the difference between data points in the first data series and the last data series. High-low lines Available in 2-D line charts and displayed by default in stock charts, high-low lines extend from the highest value to the lowest value in each category. Pie of pie and bar of pie charts display series lines by default to connect the main pie chart with the secondary pie or bar chart.ĭrop lines Available in 2-D and 3-D area and line charts, these lines extend from data points to the horizontal (category) axis to help clarify where one data marker ends and the next data marker starts. Series lines These lines connect the data series in 2-D stacked bar and column charts to emphasize the difference in measurement between each data series. Predefined line and bar types that you can add to a chartĭepending on the chart type that you use, you can add one of the following lines or bars: Specific line and bar types are available in 2-D stacked bar and column charts, line charts, pie of pie and bar of pie charts, area charts, and stock charts.