Insert trends in a Microsoft Excel workbook

To insert a trend in a Microsoft Excel workbook
TIP:
The following steps may vary depending on your version of Microsoft Excel.
  1. Open Microsoft Excel.
  2. Select the cell in which you want the trend chart to appear.
  3. Click the
    PI DataLink
     tab.
    TIP:
  4. In the
    Tag Functions
     group, click
    Insert Trend
    .
    The
    Trend Add-in Wizard
     dialog box appears.
  5. On the
    Define the Traces
     page, click
    Data from PI
    .
  6. In the
    Server name
     box, type the IP address of your module, or select a module from the list.
  7. Next to the
    Tag name
     box, click Ellipsis.
    The
    Tag Search
     dialog box appears.
  8. In the
    PI Server
     box, select the server on which you want to search the tags for your trend.
  9. Specify the other filtering criteria, and then click
    Search
    .
    The table below the search boxes is populated with the search results.
  10. Select the name of the tag for your trend, and then click
    OK
    .
    The selected tag appears in the right pane of the
    Define the Traces
     page.
  11. Select the checkbox next to the tag name, and then click
    Next
    .
    The
    Specify the time range
     page appears.
  12. In the
    Start Time
     and
    End Time
     checkboxes, set the time range from which the data will be displayed.
    The default value for
    Start Time
     is
    *-8h
    .
    The default value for
    End Time
     is
    *
     (the current time).
  13. Select the
    Enable updates
     checkbox, and then click
    Next
    .
  14. In the
    Trend title (optional)
     box, type a name for your trend.
  15. Click
    Format
    .
    The
    PI Trend Control Properties
     dialog box appears.
  16. Select the
    Vertical Scale
     property.
  17. On the
    Options
     tab, under
    Scale
    :
    1. In the
      Format
       list, select
      General
      .
    2. In the
      Position
       list, select
      Outside Left
      .
  18. Click
    OK
    .
  19. In the
    Trend Add-in Wizard
     window, click
    Finish
    .
    The trend chart appears in your Excel spreadsheet.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal