MyWraps charts

This help page describes how you can use MyWraps to generate powerful charts that visualize complex data series and their relationships.

When a MyWraps report contains the information the user wants, it can be visualized also in the form of one or more charts. Users move back and forth between the tabular view and the chart view by pressing the View button in the MyWraps toolbar.

Charts have interactive pinch-zoom controls and each data point is clickable to open the Wrap data source.

Screenshot of a chart showing weekly cleaning activities

Using charts helps you detect anomalies and see trends. Charts also make it easier to discuss complicated issues in a group.

Screenshot of a task management Gannt chart

This help page describes the MyWraps chart generator and how you can tailor MyWraps charts to your own needs.

Chart setup

Administrators predefine the chart view using the Chart button in the MyWraps toolbar.

Screenshot of the Setup Chart window in MyWraps

Chart options

Rotate chart 90° – The chart is rotated 90 degrees clockwise, making the x-axis appear on the left side of the chart. A rotated column chart is called a bar chart, with the bars extending horizontally to the right. Bar charts may be easier to comprehend than column charts when the values are durations.

Stack Chart Series – In a stacked chart, the values from the second and subsequent data series are added on top of the existing column, making it easier to compare the total value while still giving a rough breakdown of the components. The column chart above is a stacked chart, and the length of each column is the sum of the values from all the data series. The length of each stacked column shows the total value for each period.

Cumulative Data – If the chart shows data that is added to a final cost, time consumption, etc, you can have the chart automatically show the increasing sum instead of each individual value. If a data series contains 1, 2, and 4, and Cumulative data is selected, the chart shows the values 1, 3, and 7.

Data series definitions

Each cell in the wrap template that is included in the report will appear as a separate data series. You can change the order of the data series or “columns”, just click and hold on a column name and drag the column up or down in the list.

Checkbox – tick the box if you want this data series included in the chart.

Column – the name of the cell in the wrap template that contains the data for this series.

Send Column Data to – Defines how you want to use this series in the chart. Read more below.

Y Axis Name – Explains what the values in the data series represent and appears along the Y Axis. If the chart is not rotated, the Y-axis appears to the left in the chart.

Y Axis Type – Select datetime if your values contain both date and time. Select date if your values only consist of a date. Select none for all other values.

Send Column Data to

For each data series, you need to specify how you want the chart generator to use it. These are your choices:

  • none – This series is not used in the chart. This is the same as unticking the checkbox next to the column name.
  • points – This series will be represented as a colored dot, a data point. This may be useful when you primarily want to show how often a certain combination of values occurs.
  • line – The data points for each value in the series will be connected with a straight line.
  • spline – A spline chart is a line chart in which data points are connected by smooth curved lines. It is commonly used to emphasize trends in data over equal time intervals.
  • area – An area chart is distinguished from a line chart by the addition of shading between the line and the x-axis, like in a column chart.
  • column – Column charts display vertical bars. Higher values give longer columns.
  • axislabel – This is used to select the data series that contains the values for the X-axis, often a date or a period identifier. The name for this cell will be used as the name for the X-axis.
  • tooltip – When the user hovers the mouse over a data point, a tooltip appears that shows the name of the series, the X-Axis value, and the Y-Axis value. This setting allows you to include one or more additional series in the tooltip, to provide additional information about the data point without including it in the chart, e.g. for a data series that just contains text.

Chart range

For some chart types, the data series does not consist of individual data points but pairs of high-low or start-end values that can be used to visualize ranges or duration. The chart below uses such ranges to visualize duration.

Screenshot of a task management Gannt chart

In the wrap, the start date for each activity is provided in one column and the end date in another. The Chart Range window in the MyWraps toolbar is used to define the two columns that designate each such range to be used in the chart.

Screenshot of the Setup Column range window

  • Start Column – Select the column that contains the start or low values for the series.
  • End Column – Select the column that contains the end or high values for the series.
  • Range Name – Type the name of the series to be displayed using these ranges. For the example chart above, the series was named “Gannt”, as you can see in the legend.
  • Y Axis Name – Explains what the values in the data series represent and appears along the Y Axis. In the example chart, the Y Axis is called “Gannt” (the chart is rotated 90 degrees clockwise).
  • Y Axis Type – Select datetime if your values contain both date and time. Select date if your values only consist of a date. Select none for all other values.

All chart range series are added to the chart setup

All range-based series you define on the Chart range page are added to the chart defined by the Chart setup page.

  • The X Axis is defined by what you send to the axislabel on the Chart Setup page and is also used for the range-based series defined on the Chart range page.
  • If you use the same name and type for the Y Axis, the same Y Axis is used for the range-based series defined on the Chart range page as for the rest of the chart. If either is different, an additional Y Axis is created.