1 апр. 2020 г. · Highlight your X and Y data, including the headers, and go to the INSERT tab, CHARTS, and pick the chart that you want.

10 нояб. 2023 г. · Select something called a scatter chart (instead of a line chart) which will plot (x,y) points and connect them with a line in the order plotted ...

29 июн. 2017 г. · Click Format Data Series. On the right a panel should come up, click the bar graph icon and under Plot Series On, choose Secondary Axis. You can ...

4 дек. 2016 г. · You can open the format pane in the format ribbon of the chart, then select each data series and format to a solid line (default is no line).

15 февр. 2023 г. · If you use a scatter plot with lines, format the x axis, set the minimum and maximum to the values you want, and set the major units to 1 and it ...

6 апр. 2024 г. · How to create a line graph (or scatter plot?) with several lines that have only somewhat overlapping times. : r/excel.

3 апр. 2022 г. · Select the graph and then go to the “design” tab you can select “select data”. From there a pop up will form that shows the data sets within the plot.

22 июл. 2022 г. · First change your current chart to a scatter plot. Then you'll need 3 columns of 7 rows. One column will be all 0.5, one will be 1 through 7, and the third ...

14 сент. 2022 г. · You cannot plot a straight line without at least two (x,y) coordinates. You don't need 100 data points to plot the line, but you do need at least two per line.

22 дек. 2022 г. · The trick for this will be to order the xy pairs so that excel connects the points in the right order.