In many cases, indexes tell a useful comparison story. How is my dealer doing compared to the local market? How does my target compare to the overall population?

You can add an index to a bar or column chart with the help of a context series (a specialized target series that defines the larger market or population you want to compare your target against).

1. Make sure you have created your target series and context series and linked them. See Create an Index with a context series.

2. Open the configuration dialog box for the chart you want to add the index to.

3. On the Series tab, make sure only your target series is being displayed. If necessary, clear Show on Chart next to the context series. We want it to be represented as an index line, not as a bar on the chart.

   

4. On the Y AXIS tab (for a bar chart, the X AXIS tab), make the following changes to enable the index line to display:

   1. Change the value of Data to Display to the index calculation (in this example, it's New Registrations (index)).
   2. Enable the Index Decoration > Show Index Line option.
   3. Set values for the Line Color and Line Width options.

   

5. Click OK.