Part of series: DD013 – Data-Driven Chart 013 Range Charts
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.