Annotation Chart is a tool in Excel to visualize the time series data for performance, trends and comparison analysis.
There are 2 types of Annotation Chart are provided: Line and Bars.
There are 3 types of data format are supported:
1. Time Series Data without Annotation.
2. Time Series Data with Annotation and Annotation Title and text are appended after data.
3. Time Series Data with Annotation and Annotation Title and text are inserted after relevant data. Accordingly, this add-in provides 3 format of sample data to help user to build own data set.
You can add more data series by inserting more data columns. Please make sure expand the data column following the same format in the sample data you choose from.
The date range slide on the bottom of the chart makes the date range selection easier. The period buttons on the top provide another options for selecting data ranges.