3 Replies Latest reply on Aug 10, 2016 8:17 AM by Dmitry Chirkov

    Label a Line Chart with description in Excel File

    Annie Lum

      Hi All,

       

      I have 2 data sources.  1 has call records, and the other has a list of incidents by week ending date.  Currently I have been manually updating the line chart (calls) by using the Annotate option.  I would like to change this so that the incident comment comes from an Excel file.  I've attached a packaged workbook with an example of the 2 data sources.  Below is what I would like, but I've had to put in the comment manually.  I've also attached what the Excel looks like for the Incident records.  The way it is set up, it only has a record if an incident occurred for that week.  It doesn't show all weeks, but can be changed if needed.  Thanks for your help!