Microsoft Office Tutorials and References
In Depth Information
Figure 17-31: This chart displays data based on values specified by the user.
These are both dynamic names that return a range that depends on the value of StartDay and NumDays . The
two names are used in the chart's SERIES formula (I removed the filename qualifier for simplicity):
The example in this section, named first point and number of points.xlsx, is available at
this book's website.
Displaying population data
The example in this section uses the population pyramid technique described earlier in this chapter (see “Creat-
ing a comparative histogram”). Here, the user can choose two years to view population by age groups side by