![]() ![]() For this, you should select 3 columns with data - the leftmost column with text values (labels), and the two columns with numbers. The Excel XY plot templates can also draw each variable separately, presenting the same relationships in a different way. For example, here's how you can represent the data for the first four months by using the scatter graph with smooth lines and markers: Scatter with lines is best to be used when you have few data points. Scatter with straight lines and markers.Or, you can customize some elements of your graph to make it look more beautiful and to convey the correlation between the two variables clearer.īesides the classic scatter plot shown in the above example, a few more templates are available: The scatter diagram will be immediately inserted in your worksheet:īasically, you may consider the work done. To insert a classic scatter graph, click the first thumbnail: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |