This particular step is to make the overall outlook easy to read for the readers. Read More: How to Create a 3D Scatter Plot in Excel In conclusion, both of your Axis Bounds are adjusted after following the steps.Please follow your dataset to find the Maximum and Minimum values and Reset accordingly.As my dataset has only 6 Months, I will Reset the Maximum value to 0.You must Reset the Minimum and Maximum values according to your dataset value.Accordingly, choose the Format Axis option.Secondly, right-click on the Horizontal Axis.To start, click on the Horizontal Axis marked in the picture.Similarly, change the Bounds value for the Horizontal Axis.Finally, hit Enter and eventually the Maximum and Minimum value of the Axis is changed, and this step makes the chart more relevant.Since in my dataset, the range of values for Temperature is 40-80, I will reset the Minimum value as 40.0 and the Maximum value as 80.0.Here, Bounds Minimum is set as 0, and the Maximum is set as 90.0.From the options, hit the Format Axis option.Later, right-click on the selected Vertical Axis.In the first place, select the Vertical Axis of the Chart which is also marked in the snapshot.In this step I will readjust the Bound Maximum and Minimum value in Format Axis Pane. Consequently, the Chart Title has disappeared.At this point, uncheck the Chart Title.Again, click the + sign at the top right corner of the Scatter Chart.Besides, I will delete the Chart Title as I will add Labels after completing the Matrix.As a result, you can see that Gridlines from the chart have vanished.Notice that there is a tick beside the Gridlines option.Initially, click on the + sign at the top right corner of the Scatter Chart. ![]() To make the chart clean and prominent, I will remove the Gridlines and Chart Title. Step-03: Remove Chart Title and Gridlines
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |