Bar and Line Charts

Convey information in a visual manner with Bar and Line Charts.

Bar and Line Charts are a type of Chart that displays data as rectangular bars and/or a series of data points connected by line segments. You can choose whether each data series is displayed as a bar or line. 

By default, all Charts are Bar and Line Charts until you change it to a Pareto Chart or add a Threshold, Control, or Bowling Series.

Example of a Bar and Line Chart.

Who can edit a Bar/Line Chart?

Only the following people can edit a Chart's Details or its data:

• Anyone on the Chart's Team except for Followers or Participants.
• Anyone with the “Edit” permission for Items in the Chart's Location(s).

Edit a Bar/Line Chart’s Details

A Chart's Details consist of its non-data elements including:

• Fields and Attributes
• Its Parent — the Item under which the Chart is nested
• Other settings such as whether or not the Chart should be private or be granted Honor Roll may be available depending on how your organization has configured its Charts and your own permissions within the system.

To edit a Chart's Details, open the Chart with which you want to work, then:

• Click Actions in the top right corner of the page.

• Click Edit Details in the resulting drop-down menu.
• Update any of the aforementioned elements.
• Click Save.

Enter data for a Bar/Line Chart

You will use the data entry window to enter data for your Chart. A Chart's data includes not only the individual data points but also how those data points are displayed.

To start entering data, open the Chart with which you want to work, then:

• Either click Actions in the top right corner of the page or click the ellipsis in the top right corner of the panel containing the Chart.
• Click Edit Chart in the resulting drop-down menu.
• The Chart's data entry window will open. By default, Charts are Bar/Line Charts. As long as you don't select the Pareto checkbox or add Thresholds, Control Limits, or Bowling Series, it will remain a Bar/Line Chart. 

In the data entry window, you can:

• Decide whether the Chart will use dates or categories
• Add a data series
• Edit an existing data series
• Delete an existing series
• Add data rows
• Delete data rows
• Add and update data points
• Export data
• Import data

Switch between Date or Category

A Bar/Line Chart's horizontal axis can be either date-based or category-based. By default, a new Bar/Line Chart will use dates.

To change which is used, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to "Date" or "Category."
  

• In the resulting window, click either the Date or Category radio button to make your selection.
• If you select "Category," click Save.
  
  If you select "Date," additional configuration options will appear.
  
  • The Use exact dates entered checkbox: When this box is checked, the Chart will display the exact dates entered. When this box is unchecked, the Chart will automatically calculate the best dates to display to create an even interval between the dates entered.
  • The Show time on Chart checkbox: When this box is checked, the date and time for each data point will be displayed on the Chart. When this box is unchecked, only the date will be shown for each data point. 
  • Click Save.

Add a Data Series

A data series consists of the data which will be compared to the Thresholds.

When you add data to a Chart for the first time, there will be a blank data series column you can use to enter data immediately. 

• Click into each cell and enter a value. 
• Select the pencil icon to edit the data series. You can make changes such as updating the data series' color and whether it appears as a bar or a line.  

There are two ways to add a new data series to your Chart. 

• You can select the + button to the right of your existing data series. A new column will appear, and you can start entering data immediately.

• Or, you can select Add Data Series. The “Add Data Series” window will open, and you can enter the new data series settings before entering the data itself.

In the Add Data Series window or Edit Data Series window (if you are updating an existing Data Series), you can update the following settings:

• Name (required): The name will be used to identify this series.
• Description: Enter an optional description in this field. The description will appear when hovering over the name of the series on both the Edit Data window and on the Chart's legend.
• Format (required): Expand the drop-down to choose in which format you want data in this to be displayed. Once you've made a choice, the predefined format will appear in the field. Edit that predefined format to configure the appearance of this series's data further.
• Under the Type header:
  
  • Click either the Line or Bar radio button to decide whether this series should be displayed as a line or as a bar.
• Click the Appearance header to open that section. The options shown here will be largely determined by your choice of line or bar above.
  
  • If this is a line data series:
    
    • Bar/Line Color: Click inside the color code field to open the color picker, choose in which color this series will be displayed, then click Save on the color picker.
    • Line Width: The value (1–10) entered here will determine the width of this series's line on the Chart.
    • The Show Markers checkbox: When this box is checked, a round marker will appear at each data point on the series's line on the Chart.
    • The Show Values checkbox: When this box is checked, the value of each data point on this series will appear by its line on the Chart.

• • • The Send to Back checkbox: When this box is checked, this series's line will be arranged behind any other series on the Chart.
    • The Dashed Line checkbox: When this box is checked, this series will be displayed as a dashed line rather than a solid line.
    • The Fill checkbox: When this box is checked, the space beneath the series's line will be filled in on the Chart. If enabled, the following options will appear beneath the checkbox:
      • Fill Color: Click inside the color code field to open the color picker, choose in which the fill for this series will be displayed, then click Save on the color picker.
      • Fill Opacity:  Expand the drop-down to choose with what opacity you want the fill to be displayed.
  • If this is a bar series:
    
    • Bar/Line Color: Click inside the color code field to open the color picker, choose in which color this series will be displayed, then click Save on the color picker.
    • The Show Values checkbox: When this box is checked, the value of each data point on this series will appear by its bar on the Chart.
• Click the Y-Axis header to open that section.
  • Click either the Left or Right radio button to decide whether Y-axis for this series should be displayed on the left or right side of the Chart.
• The Calculated Series checkbox: Check this box to turn this series into a Calculated series. Such a series will calculate the sum, difference, average, percent, percent change, product, or quotient of other data series currently on this Chart. If checked, the "Shared Series" header will disappear and a new field will appear:
  
  • Operator: Expand the drop-down to choose which operator the Calculated series will use. Depending on the operator chosen, additional required fields will appear.
    
    • If Sum, Average, or Multiply are selected:
      
      • Series: Expand the drop-down to select every data series that should be used in this calculation.
    • If Difference is selected:
      
      • Series to subtract from: Expand the drop-down to select the data series from which the other data should be subtracted.
      • Series to subtract: Expand the drop-down to select every data series that should be subtracted.
    • If Percent or Divide are selected:
      
      • Numerator Series: Expand the drop-down to select the data series that should act as the numerator.
      • Denominator Series: Expand the drop-down to select the data series that should act as the denominator.
    • If Percent Change is selected:
      
      • Baseline or Original (% change from): Expand the drop-down to select the data series that should act as the baseline value.
      • Actual or Current: Expand the drop-down to select the data series that should act as the current value.
• The Shared Series checkbox: Check this box to turn this series into a Shared series — a series that is mirrored from another Chart. The data on such a series will not be editable on this Chart but will reflect updates made to the data series on the original Chart. If checked, the additional fields will appear:
  
  • Chart: Use this field to search for the Chart which contains the series you want to have shared. Once you've selected a Chart, the next field will be enabled.
  • Series: Expand the drop-down to select which data series from the specified Chart you would like to add.

• Click the Annotation Appearance header to open that section.
  
  • Click inside the color code field to open the color picker, choose in which color Annotations on this series will be displayed, then click Save on the color picker.
• Click Save to create the data series and return to the Edit Data window.
• Repeat this process for any additional data series you need to add.

Edit an existing series

To edit an existing series, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to the series's name.  The "Edit Series" window will open.

Delete an existing series

To delete an existing series, open the Chart's Edit Data window as described above, then:

• Click the pencil icon next to the series's name.  The "Edit Series" window will open.
• Click Delete. The "Edit Series" window will close and the series will no longer appear on the Edit Data window.
• Click Save to update the Chart.

Add rows

Once at least one series has been added to the Chart, you will be able to add rows. To do so, open the Chart's Edit Data window as described above, then:

• To add a single row, click Add Row.
• To add multiple rows at once, click Build Multi Rows. A new window will open so that you can specify how many rows will be added. The options on this window will differ based on whether the Chart is using dates or categories.
  • If using dates:
    
    • Start Date: Enter the date of the first row to be added.
    • End Date: Enter the date of the last row to be added.
    • Step Unit: Expand the drop-down to choose whether a row should be added for each day, each week, or each month between those two dates.
    • Click Save.
  • If using categories:
    
    • Row Count: Enter the number of rows that should be added.
    • Click Save.
• Once rows have been added, click the date or category field for each one to change its date or name.
• Click Save to update the Chart.

Delete rows

To delete an existing row, open the Chart's Edit Data window as described above, then:

• Hover over the row you want to delete so that it's highlighted blue.
• Click the x button that appears to its right. The row will disappear from the Edit Data window.
• Click Save to update the Chart.

Add and edit data

After rows have been added, individual data points can be entered. To do so, open the Chart's Edit Data window as described above, then:

• Click inside the appropriate column and row intersection. The selected cell will have a blue outline.
  
  
  • Enter the desired value. 
• Select "enter" on your keyboard to continue entering data in the same column. 
• You can navigate between cells using the arrow keys or "tab" key on your keyboard. 
• Click Save to update the Chart.

Export the Chart's data

To export a Chart's data, open the Chart's Edit Data window as described above, then:

• Click the Excel File icon.

• Click Download in the resulting drop-down.
• If your Chart is using dates, you will need to select a Time Zone and then click Download in the resulting window.

Import data into a Chart

To import data into a Chart, open the Chart's Edit Data window as described above, then:

• Click the Excel File icon.
• Click Upload in the resulting drop-down.
• The "Chart Data Import" window will open:
  • If your Chart is using dates, you will need to select a Time Zone.
  • Either drag the file you want to import onto the resulting window or click the window and choose the correct file from your computer.
  • A confirmation screen will appear with details about your import. Click Ok, got it.

Everything else!