![]() ![]() ![]() 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:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |