Microsoft Office Tutorials and References
In Depth Information
FIGURE 7.11 Contour and Wireframe Contour Surface Charts
FIGURE 7.12 Surface Chart with the Data on the Chart
I chose one more example you can find on the same sheet in the Chapter 7
workbook. This time the data creates a concave surface. To enhance the presentation
of the chart I copied the values of the grid as a picture. Then I pasted the picture on
V). Now you can
see the Z values corresponding to the values or heights of the points on the chart. See
Figure 7.12. You may want to use Conditional Formatting on the grid
(you select the floor and use paste or CTRL
s values before
you paste it on the chart.
You may want to dynamically change the data a chart is based on to cause parts of
the chart to move and illustrate its impact on your decision-making process. For
example, the Break-Even Point changes as you change the input values such as costs,
selling price, fixed costs, or any other input. You may want to see the impact of
moving your plants on a map on cost in a supply chain distribution problem.
I will start with a Break-Even Point chart example. The example used to create
the chart is shown in Figure 7.13. The Break-Even Point (BEP) is 6,250 units. In other
words, when the number of units sold exceeds 6,250 units this venture is profitable.
You will find this example of this chapter
s workbook on the sheet Animate a Chart.