Unique Excel Line Chart With Multiple Series
Right click on the chart and click on Select Data from the pop up menu.
Excel line chart with multiple series. Hide the new series and add the horizontal lines. X - Y _____ 1 - 5 2 - 5 5 - 7 9 - 10 Graph 2. Click at any place of the chart you want to add series line to show Chart Tools group in the Ribbon.
Ad Get More Results from Your Graphs for Less Effort. Excel has detected the dates and applied a Date Scale with a spacing of 1 month and base units of 1 month below left. Select the series you want to edit then click Edit to open the Edit Series dialog box.
I have a line chart with multiple series on it say 10-15 series. Graph 1 X and Y are defining a coordinate. Click Line with Markers.
Select cell B2 and type in a formula. Click in the Series Name box and add a descriptive label. I would like to format all line series on the chart to have a heavier width so that they are more visible.
In this post I will show you how we can create line charts with multiple series using VBA. One of several video tutorials created for students in Carleton Universitys Found. Double click the series.
You only can add series line in 2-D stacked ColumnBar Pie of Pie or Bar of Pie chart. There I create two series and choose X and Y values. However this doesnt work since it doesnt allow me to choose different X values for.