Framework: DD013 – dd013_v03
This is a variation on a subdivided bar chart in the PowerPoint chart gallery. There is no range chart/stock chart for bars. Therefore, we need to improvise. This is plotted much the same way a waterfall is plotted. The first column in the worksheet contains a value for a no-fill, no-line field that creates a spacer between the bar and the baseline. In this case the value of that spacer is the low value. The actual value of the bar, or the high value minus the low value. The numerical values are not formatted to appear. Let the value axis and gridlines provide that information.
When you place this chart into your template, it will take on the default setting in your template. Refer to the tutorial for this series, the FAQs and best practices for data-driven charts, and the feature article for October 2006 for more information on uses and formatting.
Part of series: DD013 Data-Driven Charts 013
Series Keywords: range, high and low values, average
Range charts show a beginning and ending value in relation to a value axis. Typically the range charts do not display numerical values, but rely on the grid lines associated with the value axis to illustrate values.
The charts will assume the default settings in your company's presentation template when they are imported. Refer to the tutorial for this series, the FAQs associated with working with data-driven charts, and the best practices for information on how to use and format these charts.
Key search words: range, high and low values, average