Data-Driven Charts 013 – Range Charts
Working with Range Charts
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 gridlines associated with the value axis to illustrate values. Range charts v01 and v02 are native to PowerPoint and don't require any special data-input techniques. Range chart v03 is a variation on a subdivided bar chart: it needs to have spacer segments plotted in the worksheet. See the guide below about how to accomplish this.
Customizing data-driven charts
To adjust the size of a data-driven chart, you must double click on it and then adjust it by pulling the corner handles. Do not size without double-clicking on the chart. The text will skew and the chart may even eventually corrupt if you size incorrectly. This is important. The text may scale as you do this (which is an option you can choose or not choose). We recommend that you do not scale your text, as font size consistency is important for readability.
The color will adjust to your template's default color scheme when imported. The color is formatted to assume the primary fill color in your template. If you want to change the color/create a highlight color for one of the segments, you can do so by double-clicking and then clicking again on the segment you wish to change. Select a new color from the Pattern menu that will pop up.
3D is not recommended. 3D in charts is ambiguous and imprecise. The idea behind presenting data is to be precise. Never sacrifice clarity or concision for the sake of style.
Shadows are not recommended
Gradients, patterns, and pictures
Gradients can work in range charts, but be consistent. If you use gradients, be sure to use them in all of the data-driven charts.
Animate with a purpose. Simple reveals are much more effective than the more "startling" animations, unless of course you are trying to startle your audience. Add pizzazz by way of content, not by adding sparkly accessories.
Series that relate to this tutorial
Click on a name for more information.
Click on a thumbnail to view a larger image