In our example, the blue dots represent advertising cost, and orange dots represent the items sold: 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.
0 Comments
Leave a Reply. |