Add or remove series lines, drop lines, high

Excel for 10kiem.vn 365 Outlook for 10kiem.vn 365 PowerPoint for 10kiem.vn 365 Excel for 10kiem.vn 365 for Mac PowerPoint for 10kiem.vn 365 for Mac Excel 2019 Outlook 2019 PowerPoint 2019 Excel năm 2016 Excel 2019 for Mac PowerPoint 2019 for Mac Outlook năm nhâm thìn PowerPoint năm nhâm thìn Excel 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Outlook 2010 PowerPoint 2010 Excel năm 2016 for Mac PowerPoint năm nhâm thìn for Mac OCS-Communicator thiết bị di động 2010 More...Less

You can add predefined lines or bars lớn charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, & up-down bars, khổng lồ specific chart can help you analyze the data that is displayed. If you no longer want khổng lồ display the lines or bars, you can remove them.

Bạn đang xem: Add or remove series lines, drop lines, high

New lớn formatting charts in Excel? Clichồng here for a không tính phí 5 minute Clip training on how lớn format your charts.

Specific line and bar types are available in 2-D stacked bar and column charts, line charts, pie of pie & bar of pie charts, area charts, & stochồng charts.

Predefined line và bar types that you can add to a chart

Depending on the chart type that you use, you can add one of the following lines or bars:

Series lines These lines connect the data series in 2-D stacked bar and column charts khổng lồ emphaform size the difference in measurement between each data series. Pie of pie và bar of pie charts display series lines by mặc định to connect the main pie chart with the secondary pie or bar chart.

*

Drop lines Available in 2-D và 3-D area and line charts, these lines extover from data points to lớn the horizontal (category) axis to help clarify where one data marker ends & the next data marker starts.

*

High-low lines Available in 2-D line charts và displayed by mặc định in stoông chồng charts, high-low lines extend from the highest value to the lowest value in each category.

*

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 và the last data series. By default, these bars are also added to lớn stochồng charts, such as Open-High-Low-Cthất bại và Volume-Open-High-Low-Cthảm bại.

*

Add predefined lines or bars to lớn a chart

Cliông xã the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stoông chồng chart to lớn which you want lớn add lines or bars.

This displays the Chart Tools, adding the Design, Layout, & Format tabs.

On the Layout tab, in the Analysis group, vì one of the following:

Cliông xã Lines, & then clichồng the line type that you want.


Note: Different line types are available for different chart types.


Click Up/Down Bars, and then cliông xã Up/Down Bars.


Tip: You can change the format of the series lines, drop lines, high-low lines, or up-down bars that you display in a chart by right-clicking the line or bar, & then clicking Format .


Remove sầu predefined lines or bars from a chart

Cliông xã the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stoông chồng chart that displays predefined lines or bars.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

Xem thêm: Những Bức Thư Upu Hay Nhất Cuộc Thi Viết Thư Quốc Tế Upu, Những Bức Thư Giải Nhất Quốc Gia

On the Layout tab, in the Analysis group, cliông xã Lines or Up/Down Bars, và then click None to remove lines or bars from a chart.


Tip: You can also remove lines or bars immediately after you add them to lớn the chart by clicking Undo on the Quiông xã Access Toolbar or by pressing CTRL+Z.


You can add other lines lớn any data series in an area, bar, column, line, stoông xã, xy (scatter), or bubble chart that is 2-D & not stacked.

Add other lines

This step applies khổng lồ Word for Mac only: On the View thực đơn, cliông chồng Print Layout.

In the chart, select the data series that you want to lớn add a line to, & then click the Chart Design tab. 

For example, in a line chart, clichồng one of the lines in the chart, & all the data marker of that data series become selected.

Click Add Chart Element, và then cliông xã Gridlines.

*

Choose the line option that you want or cliông xã More Gridline Options.

Depending on the chart type, some options may not be available.

Remove other lines

This step applies to Word for Mac only: On the View thực đơn, cliông xã Print Layout.

Clichồng the chart with the lines, and then click the Chart Design tab.

Xem thêm: Bảng Xếp Hạng Jupiler League 2020/2021, Bảng Xếp Hạng Vđqg Bỉ

Cliông chồng Add Chart Element, clichồng Gridlines, & then cliông xã More Gridline Options.


Chuyên mục: Tin Tức