Excel Keeps Plotting Two Lines Instead Of One

IT Support Forum Forums Windows Windows 10 Applications Excel Keeps Plotting Two Lines Instead Of One

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 1 year, 4 months ago.

  • Author
    Posts
  • #1313

    Webmaster
    Keymaster

    Annoyingly Microsoft Excel keeps plotting two lines instead of one. If Excel plots two lines from your data set instead of one, this can be fixed by changing the data set.

    By default, when you select some data to turn into a graph, Excel will plot each column as a line and use the column to the left of the selected data as the scale (axis). This is contrary to what you would expect when you select two columns, as you’d expect the two columns to be plotted against each other producing a single line. Instead you get two lines, one for each column.

    To plot a single line on the graph in Excel, select only one column and plot a graph using that. Excel will use the column to the left as the measure to plot the points against.

    ❗ Still getting two lines instead of one? Make sure you only select one column of data to plot the graph against. Try moving the columns around and selecting different ones until the graph looks the way you want it.

You must be logged in to reply to this topic.