bulldanax.blogg.se - Connect dots on scatter chart excel

The scatter chart recognizes the numeric values attached to the labels.

The line goes from 1 to 5, back to 3, then 4, 2 and 6.

Each data point is matched to its label’s value.

The numbers on the X axis are in correct numeric order.

As a result, the chart looks like a wacky connect-the-dots puzzle. The scatter chart, at the right, recognizes the numeric values in column A of the chart’s source data.

The line chart is blissfully unaware of any values attached to the labels.

Each data point is matched to its label, in the order they’re listed in the chart’s source data.

The numbers on the X axis appear in the order they’re listed in the chart’s source data.The line chart, at the left, treats the month numbers as text labels. However, if the month numbers aren’t listed in order, the difference between a line chart and scatter chart become more obvious. Line Chart Vs Scatter ChartĬan you spot the differences between an Excel line chart and an XY (scatter) chart? They can look very similar, as in the monthly sales example shown below.ĭid you recognize the scatter chart as the one on the right? There are slight differences in the X axis, and how the data points line up with the axis labels. If you could have one new Excel feature, is that what you’d ask for? Maybe not, but if that tweeter reads to the end of this blog post, there’s a link that will help. “It’s 2010… come on Excel… all I want for Christmas is a 3d scatter chart, it’s not too hard! I don’t want to have to fire up Processing!”.Last week, someone tweeted a wish for a new Excel Chart type: