Skip to main content
InSource Solutions

TN HistClient133 Using The Historian Client Analog Tag Analysis In Excel




This article from InSource shows how to quickly and easily take advantage of some pre-built reporting capability in the Historian Client's Excel plug in called the tag analysis.  There are 6 different types of tag analysis' built in (analog, batch, scatter, discrete, analog value at discrete transition, and analog-discrete pair).  This article will illustrate how to build and manipulate the analog tag analysis.

  • Author: Lewis Talley
  • Published: 03/10/2017
  • Applies to: Historian Client (Excel plug in)


The Excel plug in is a very powerful tool for using the capability of the Historian Client directly from Excel.  When Excel is present (or the add-in is manually added) when the Historian Client is installed, there is a new ribbon menu added as shown: The "Tag Analysis" button allows us to access the analog tag analysis feature.

step 1.jpg

Clicking on "Tag Analysis" will go into a 5 step wizard as shown:

step 2.jpg step 3.jpgstep 4.jpgstep 5.jpgstep_6.jpg

Below you will see the report.  Most people do not realize that you can change the values (of the range for instance), and the report will update automatically:

report done.jpg