--- title: "Charts" slug: "charts" updated: 2024-02-02T11:55:54Z published: 2024-02-02T11:55:54Z canonical: "kb.dataparc.com/charts" --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.dataparc.com/llms.txt > Use this file to discover all available pages before exploring further. # Charts Data can be put into charts, such as Trend, Histogram, or X/Y plots directly from Excel. These charts are not PARCview charts, but Excel charts. Click on the **Charts** button in the settings pane. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image081_003.jpg) Click on the desired type of chart in the popup window. For Histogram, Trend Tags, and CUSUM, a column must be selected before clicking this button. For X/Y Plot, two columns must be selected. **Histogram:** Produces a chart on the current sheet that shows the distribution of different values. **X/Y Plot:** Produces a scatter plot with a linear fit comparing two tags. By default, the leftmost tag will be set as Y. **Trend Tags:** Produces a plot of the tag’s values over time, much like a Trend in PARCview. **Cross Corr**: Produces a new sheet that cross correlates all columns to determine which values are correlated. See below for more information. **CUSUM:** Creates a new sheet that displays a data table and chart of the cumulative sum of a tag over the time period specified in the sheet. Modify the parameters in column B and click Calc CumSum to recalculate. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image083_002.jpg) **MSR:** Produces a chart of the Maximum Sustainable Rate at a specified percentage. ### **Cross Correlation Chart** Upon selecting this chart, select **Yes** or **No** to select the desired relationship. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image085_002.jpg) The data that results from this is the slope of the linear fit line produced after making an X/Y plot of all the data points for those two columns. The cells are formatted to change color based upon certain correlation values. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image087_001.jpg) There are also buttons that manipulate the data displayed and create new plots. Click **See Comment** to see button descriptions within the sheet. Besides XY Plot and Trend Tags, these actions cannot be undone without creating a new CrossCor sheet. **Sort**: Sorts the rows within a selected column in order from highest correlation value to lowest. **Remove <.4:** Removes rows and columns where all correlation values are less than .4. **Remove <.6**: Removes rows and columns where all correlation values are less than .6. **XY Plot:** Creates an X-Y plot of the two tags from the highlighted cell. This chart is identical to the X-Y plot produced from the normalized sheet. **Trend Tags:** Produces a plot of the tags’ values over time, much like a Trend in PARCview. This chart is identical to the Trend Tags plot produced from the normalized sheet, and will contain trends for both tags from the selected correlation cell. **Optimum**: Shifts the timestamps of each tag relative to the others to find the best correlation between tags. Often there will be a time delay observed in a correlation. The maximum Interval Shift must be specified. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image089_001.jpg) The time shifts will be displayed in new columns and the correlation values will be adjusted. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image091_001.jpg)