Choose 8 in the Size control and click OK. Right-click any of the values on the Y axis, choose Format Axis, and click the Font tab.Right-click the X axis (the flavors), choose Format Axis from the resulting context menu, and then click the Font tab.Let’s adjust some of the formats to make the chart a bit more readable: ![]() ![]() To see a menu of all available chart types in newer versions of Excel, click the down arrow by "Charts" in the Charts section of the ribbon's Insert Tab.The resulting chart needs a bit of work. Other Chart TypesĮxcel offers other charts such as Stock, Surface, Doughnut, Bubble, and Radar. The series pair has a Positive Correlation if they increase similarly, and a Negative Correlation if they both decrease in like manner. See Scatter Charts with Lines to understand why this happens and how to fix it. Sometimes scatter charts with lines can be confusing if the line zig-zags and crosses itself. In general, markers work well when the number of data points is small, and smooth lines are often used with a large number of data points. Scatter charts come with or without markers, and data points can be connected with smooth or straight lines. The scatter chart is called the XY Chart because its data points are the intersection of two values on the X and Y-axis. ![]() The SCATTER Chart observes the relationship between two variables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |