跳到主内容

Annotation Chart

Garden City Consultants

A tool to visualize the time series data with annotations in line and bar charts

Description:

Annotation Chart is a tool in Excel to visualize the time series data for performance, trends and comparison analysis.

Annotation Chart provide two chart types:

  • Line Chart

  • Bar Chart

There are 3 data formats:

  • Time Series Data without Annotation.

  • Time Series Data with Annotation and Annotation Title and text are appended after data.

  • Time Series Data with Annotation and Annotation Title and text are inserted after relevant data.

This add-in provides 3 sample data sets to help user to build own data set.

The userr can add more data series by inserting more data columns. Please make sure expand the data column following the same format in the selected sample data.

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.

Features:

  • This add-in is easy to use. It allows user to use sample data as the template to build his own data set by pasting the same format data into the sample data table.

  • If more data is added, just add more columns of data into the spreadsheet, then click "Bind to existing data" to redraw the chart.

  • Date slide on the bottom allow the user select date range.

  • Period buttons on the top allow the user select period.

  • Mouse over the data series, the value is shown at the top of the chart area.

  • Annotation title and text are shown at the annotation area that can be adjusted in the setting window.

  • Chart height can be adjusted according to the user's screen.

  • 3 types of format can be chosen by using sample data.

  • 2 color schemes for background can be chosen.

  • Chart height can be adjusted according to user's screen.

  • Annotation area width can be adjusted.

Instruction:

  • Download this add in and start Excel 2013 SP1 or later Add in.

  • Click Insert Sample Data button to insert the sample data and view the line chart.

  • Build own time series data and follow the same format as in the sample data, then paste into the sample data table to replace the sample data. Adding more columns as needed in the spreadsheet table.

  • If the annotation text want to be added, selecting a data format that support the annotation and clicking the "Insert Sample Data" button to insert the sample data. After the sample data is inserted, replace the data with the data and enter the annotation title and text in the Annotation Title and Text columns as needed.

  • Click in the title area to enter desired title.
外接程序功能
在使用此外接程序时,它
  • 可读取文档并对其作出更改
  • 可通过 Internet 发送数据
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_0a7f02d4-c169-452a-9b39-aa08987a5233/AnnotationChart2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_0a7f02d4-c169-452a-9b39-aa08987a5233/AnnotationChart2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_de966b27-ddfc-4e58-9183-49a3b81c3bfd/AnnotationChart3.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_3dc7b1df-fc83-4fbc-a90c-55ecf2a0eac7/AnnotationChart4.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_f2f5c967-2335-4d9e-8b46-88ce6239c734/AnnotationChart5.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679692/Asset_5967c4a8-cd44-4253-a9ca-7a37de3ad7d2/AnnotationChart6.png