And then on the x-axis I have the increase in bid requests. I don't have a label, but I know that's what they are. Along the bottom of the chart I see that I have my discount levels, my amount of discounts. And from here I just want to plot the individual points so I will click the Scatter button, the one on the top row to the left. To create an x, y scatter chart with the way the data is laid out here in the table, I will click any cell in the table and then on the insert tab of the ribbon, I'll go to the charts area and then I will click the x, y scatter button. You can see the amount of discounts from 100 to $350 in column A and the corresponding increase in bid requests in column B. And we do our testing to determine the number of bid requests we received in response to each of these individual discounts. Working with our data scenario around Kinetico Corporation, let's say that we want to offer discounts to individuals who make a bid request for a solar panel installation by a certain date. My sample file is the XYChart workbook and you can find it in the chapter seven folder of your exercise files collection. In this movie, I will show you how to create x, y scatter charts where you measure two numerical variables and plot the information on a chart. In the previous movie I should you how to create line charts which represent data over time.
0 Comments
Leave a Reply. |