![]() So, we will do the following formatting for them with the steps below. To remove the unwanted white space around the data points, we can format the X and Y axes by changing the initial point of the graph.įor example, in this graph, 30 is the first value along the Y-axis. Read More: How to Create a Chart from Selected Range of Cells in Excel Chart Titleīy clicking double on the chart title, we can give a new title as we wish (e.g., Apple Sale vs Number of Months). In this section, we will cover some of the customizations we can do with an X Y graph in Excel. Just like any other chart in Excel, We can easily customize the X Y Graph. Note: It’s best to have the independent metric in the left column and the one for which you need to find the correlation in the column on the right. Here, the column on the left which is the Number of Months in our example would be plotted on the X-Axis and the Apple Sale would be plotted on the Y-Axis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |