![]() ![]() At the bottom of the effects, click on the option uncheck from Autoscale. Press the right-click on the chart and click on the Format Chart Area. For example, it ranges from -20,000 to 60,000, but our data on the profit/loss is only between 7,000 to -5,000 and 30,000 to 40,000, so we need to change it. The colors indicate value ranges in the chart.The 3D chart currently looks like this one below,.Select the data in which we want to plot the 3D chart.Another is the company’s profit or loss, and the third is the total sales made in that period of a month. We want to show this in the 3D chart as we have three variables to define. Suppose we have data for a region whose sales are made over six months, and we want to display this data in a chart. Let us use 3D surface plots in Excel for some tricky situations. The above surface chart is the 3D plot for the random data selected above. We can give the axis title by clicking on the button provided by Excel. The chart will now look as shown below after changing the default rotation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |