The Barchart Editor Histogram
  • 15 Aug 2024
  • 19 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

The Barchart Editor Histogram

  • Dark
    Light
  • PDF

Article summary

The Barchart Editor Histogram

In addition to the Grid and the Gantt chart, the Barchart Editor has six panes: Activity information, Link Information, Resources, Histogram, Risk, and Logic Navigator.

Configuring Barchart Editor Histogram

The Histogram pane provides feature-rich functions that allow you to view periodic and cumulative data presented as bars and lines together with table data. At the same time, you add, edit, modify, or browse through your project activities.

The Histogram pane not only serves as a barchart sub-view but also as a reporting tool due to its rich formatting capabilities. In addition to presenting scope, cost, and qty data, the Editor Histogram report may give periodic or cumulative summarised and aggregated information in userfields.

The information presented can be grouped, stacked, and spread. You can apply filters across the Barchart and the Histogram or create a filter to be applied to the Histogram view only. You can also create summarised reports or set a "page by" definition to produce a report that spans several pages summarised by the selected field.

The layout and data content features are numerous. You may add horizontal and vertical lines and curtains to highlight important information. You can print the reports directly from the view or examine the graph in a full-size preview before printing. If you create report specifications from this view, they can be included in your report groups and packages. Reports can be saved to SWA, or report specifications may be run from the SWA client.

Specifications can be exported and imported to be shared between different Safran Planner databases.

Configuring Barchart Editor Histogram

How to create a new histogram

  • Click View - Histogram or right-click on the legend bar and then click Histogram.
  • Drag the grey horizontal line under the legend area to adjust the size of the histogram view.
  • Right-click in the histogram view and then click on histogram properties.
  • Click the Save As or New button in the top right corner and enter a name in the dialogue box.

To modify your report, see Histogram Properties.

Histogram Properties

To specify the appearance of the line graph, profiles, and histogram, use the Histogram Properties window. The Histogram Properties window is a tab-separated window that allows you to specify appearance, content, and data fields. You can also save your formatting with a report name for later re-use. We will now look at the different sections of the Histogram Properties window, starting with the Report section.

Configuring Barchart Editor Histogram

Top

The histogram properties can be saved for later use by adding and saving a report name.

Configuring Barchart Editor Histogram

Fields and buttonsDescription
NameSelect a report from the drop-down list.
Reports FromReduces or increases the number of reports in the drop-down list.
NewCreate a new histogram report (enter a name in the New Report dialogue box).
Save AsSave the selected histogram report with a new name (enter a name in the Save Report As dialogue box).
RenameRename the selected histogram report.
DeleteDelete the selected histogram report (click the OK button in the Delete Report dialogue box to confirm).

Bottom

SP%20BE%20Histogram%20Comments

Fields and buttonsDescription
Comments...Allows the report owner to add a longer descriptive text to the report.
PreviewAllows you to preview modifications before saving the report.
ApplyApply changes have the same effect as OK, except that the Properties window remains open.
OKSaves all changes and closes the properties window.
CancelChanges performed in the properties since last saved (Apply/OK) are undone - Properties window closes.

The comment will also be available in the Report Package 'Order' tab:

SP%20BE%20Histogram%20Report%20Package

The following two topics will look at the following tabbed sections.

Histogram Setup

SP%20BE%20Histogram%20Setup

Histogram Entries

SP%20BE%20Histogram%20Entries

Histogram Setup

The content of these tabs is described in this section.

SP%20BE%20Histogram%20Setup

Page

The Page tab lets you select a background picture to be overlaid by the graph, and it allows you to specify page orientation. Using the 'Page on' options, you can produce multi-page reports divided by codes in a reference field or levels in an Outline Code.

Please note that if you have entered Resource availability for Reference or Outline codes, these can be added as entries for the graph and presented as profiles, line graphs, or bars on the page.

To view a Barchart Editor Histogram with multiple pages, you can either present the graph in the Print Preview window and view this page-by-page or scroll through the Histogram view.

SP%20BE%20Histogram%20Page

X Axis

The X-axis interval applies to curves, histograms, and table data intervals. The user can set the period, which does not have to be identical to the Gantt period.

SP%20BE%20Histogram%20x-axis

SP%20BE%20Histogram%20Span

Fields and buttonsDescription
SpanThe histogram can be displayed over the Total plan, for the Activity (current activity), Locked (for a period of time), or the same time span selected in the Gantt Timeline.
StartIt is available when Span is locked. Enter a start date in this field.
FinishIt is available when Span is locked. Enter a Finish date in this field.
IntervalSelect the interval and the period (year, quarter, project month, month, week, day) from the drop-down list.
Date FormatSelect the date format from the drop-down list.
Rotate TicksTick this checkbox if you want the date/text to be rotated 90 degrees to the left.
Tics FontSelect font type, colour, size, bold, italics, and underline.

Left/Right Axis

The left and right Y-Axes are formatted individually. The left axis represents the periodic values, while the right axis represents the cumulative lines (S-curves). You can specify axis description, select font and colour, tics, max value, number of decimals displayed, and factor for large numbers (millions, thousands, none). The periodic axis and data can be shown as quantities/numbers or manpower. The cumulative (right axis) can show numbers/quantities or percentages.

Left Axis (Periodic values):

SP%20BE%20Histogram%20Left%20Axis

Right Axis (Cumulative values):

SP%20BE%20Histogram%20Right%20Axis

Fields and buttonsDescription
DescriptionText field, text displayed in the left/right axis.
Data TypeLeft axis: Select between Field Value and Manpower. Right axis: Select between field value and Percentage.
Max ValueEnter the maximum value for the axis scale.
Tics DecimalsEnter or select the number of decimals you want to show from the spinner box.
FactorSelect None, Thousands, or Millions from the drop-down list.
LayoutSelect between layered or clustered.
Min ValueEnter the minimum value for the axis scale.
Major TicsEnter the steps of the tics.
Grid StyleSelect grid style from the drop-down list.
Factor TextAvailable when selected Factor is other than None. When ticked, the selected Factor will be displayed on top of the left/right axis (scale).
Description fontSelect a font type, colour, size, bold, italics, and underlined for the description.
Tics fontSelect a font type, colour, size, bold, italics, and underlined for the tics.

Clustered looks like this

SP%20BE%20Histogram%20Clustered%20look

(The thickness of the bars is controlled by 'Separation' in the Periodic Entries tab)

Layered looks like this

SP%20BE%20Histogram%20Layered%20Look

Major Tics

100 vs 1000
SP%20BE%20Histogram%20Major%20ticks

SP%20BE%20Histogram%20Major%20ticks%201000

Max Value/Min Value/Major Tics

This
SP%20BE%20Histogram%20Max%20Min%20Major%20Tics

would look like this

SP%20BE%20Histogram%20Max%20Min%20Major%20Tics%20Example%20Histogram

Grid Styles

SP%20BE%20Histogram%20Grid%20Styles

Table/Values tab

The Table/Values tab allows you to specify the appearance of the data in the table. Formatting options include title font, font size and colour, grid, and more. If you remove the default visible check mark, your report will be displayed without the table.

SP%20BE%20Histogram%20Table%20Values

Fields and buttonsDescription
VisibleTick this checkbox to display a table under the histogram.
Values Font SizeFont size for the table content.
TitleHeader title for the table.
Rotate ValuesTick this checkbox to rotate the values 90 degrees to the left.
GridTick this checkbox for the grid in the table.
Title FontSelect a font type, colour, size, bold, italics, and underlined for the title.

Lines tab

You use the Lines tab to add vertical or horizontal lines across the graph area. In the Vertical tab, you specify a Date, Line Style, Line Colour, Line Thickness, Text and Text Position. You can add as many lines as needed.

Vertical:

SP%20BE%20Histogram%20Lines%20Tab

Planner BE Histogram Lines tab Histogram

Horizontal:

SP%20BE%20Histogram%20Horizontal%20Lines

SP%20BE%20Histogram%20Horizontal%20Lines%20Histogram

Fields and buttonsDescription
DateEnter a date where you want to position the vertical line.
TextText is displayed together with the vertical line.
Text PosText Pos is a spinner box in which you can select from 0 to 100 using the arrows (intervals of 5) or enter the value using the keyboard. The number is a percentage of the height of the Gantt area (0% = at the top and 100% = at the bottom).
Line StyleSelect a line style from the drop-down list.
Line ColourSelect a colour from the drop-down list.
ThicknessSelect or enter line thickness.
AxisPlease select whether the Value will be assigned to the values on the Left Axis or the values on the Right Axis.
ValueEnter the value at which you want the line to be positioned.
NewAdds a new line to the list.
DeleteDeletes the selected line from the list.

Curtains tab

Use the Curtains - Vertical tab to define background shading to highlight specific periods ( for example, a shutdown period, a test and commissioning period, holidays, weather windows, lifting campaigns, tow out, and more).

Vertical:

SP%20BE%20Histogram%20Curtains

Planner BE Histogram Curtains tab Histogram

Horizontal:

SP%20BE%20Histogram%20Curtains%20Horizontal

Planner BE Histogram Horizontal Curtains tab Histogram

Fields and buttonsDescription
Start DateEnter a Start Date or select a date from the global dates Date/Time, Timenow, CutoffDate or Project Start in the drop-down list.
Until DateEnter a Date or select a date from the global dates Date/Time, Timenow, CutoffDate or Project Start in the drop-down list.
ColourThe curtain colour can be selected here.
HatchHatch style can be selected here.
Hatch ColourHatch colour can be selected here.
TextIf you want text together with the curtain, enter the text here.
Text PosText Pos is a spinner box where you can choose from 0 to 100 using the arrows (intervals of 5). You can also enter the value by the keyboard. The number is a percentage of the height of the Gantt area (0% = at the top of the Gantt area and 100% = at the bottom).
AxisChoose if the Values will be assigned to the values on the Left Axis or the values on the Right Axis.
From ValueEnter the From Value.
Until ValueEnter the Until Value.
NewAdds a new curtain to the list.
DeleteDeletes the selected curtain from the list.

Symbol Legend

The symbol legends tab allows you to specify the text font, font colour, font style, and size for the symbol legend display. The page setup controls the report's appearance.

SP%20BE%20Histogram%20Curtains%20Symbol%20Legend

Fields and buttonsDescription
Text FontSelect a font type, colour, size, bold, italics, and underlined for the Symbol legend.

Header

A Header displays additional information in your report. You can include information such as the company name, schedule title, etc.

SP%20BE%20Histogram%20Header

FunctionalityDescription
Left Logo – SliderSelect scaling for the logo.
Left Logo – ChangeClick the Change button to add a picture as a logo.
Left Logo – ClearRemoves the logo.
Titles – LeftThree lines of text where you can enter text or select values from the drop-down list.
Titles - CentreThree lines of text where you can enter text or select values from the drop-down list.
Titles – RightThree lines of text where you can enter text or select values from the drop-down list.
Font/Colour/Size/Bold/Italics/UnderlineEach title line can be formatted in font, colour, size, bold, italics, and underlined (ensure you are in the correct field when you apply formatting).
Right Logo – SliderSelect scaling for the logo (bmp only).
Right Logo – ChangeClick the Change button to add a picture (bmp) as a logo.
Right Logo – ClearRemoves the logo.

Footer

The footer is used to display additional information about the schedule.

SP%20BE%20Histogram%20Footer

FunctionalityDescription
LeftSelect a field and enter the text from this combo box (if you combine field and text, select the field first and then enter the text).
CentreSelect a field and enter the text from this combo box (if you combine field and text, select the field first and then enter the text).
RightSelect a field and enter the text from this combo box (if you combine field and text, select the field first and then enter the text).
Font/Colour/Size/Bold/Italics/UnderlinedFormat the text for the fields above.

Legend

The Legend appears at the bottom of the page, above the footer. It can include 19 rows of legend information and four columns of legend Items.

SP%20BE%20Histogram%20Legend

FunctionalityDescription
Legend Items – Columns 1-4In the Legend area, you can add different types of information in 4 columns and several numbers of lines for each of the columns. Each line with information consists of two fields. The first is similar to a label, and the other is for the information. This information can be either text or values from the drop-down list.
VisibleTick this checkbox to display the Legend items in the report.
New RowAdds a new row in the selected column.
Delete RowDeletes the selected row in the selected column.
Font/Colour/Font size/Bold/Italics/UnderlinedApply text formatting for the selected row.

Margins

Specify each margin individually. Changing margin settings will align the report on your paper.

SP%20BE%20Histogram%20Margins

FunctionalityDescription
Margin LeftEnter the margin size.
Margin TopEnter the margin size.
Margin RightEnter the margin size.
Margin BottomEnter the margin size.

Resources

In the Resource tab, you may filter out which resources to report using a window familiarised with the filter window.

SP%20BE%20Histogram%20Resources

Fields and buttonsDescription
Parenthesis, Field, operator, expression, parenthesis, andInput the criteria for the Filter to select the activities you want Assign Fields to affect.
New RowInserts a row above an existing row.
Delete RowDeletes the selected row.
Clear AllRemove all rows in the Formula area.

Histogram Entries

  • Periodic Entries - Defines which bars to be displayed in the histogram report
  • Cumulative Entries - Defines which s-curves to be displayed in the report
  • Table Entries - Defines which table data to be displayed in the report (periodic, cumulative, totals or stacked values)

SP%20BE%20Histogram%20Entries

Periodic Entries tab

Histograms and profiles show periodic quantities per period. Select a profile to display a continuous profile line across the time scale. Select Histogram to display separate columns for each period. Columns may be stacked, layered, or clustered and separated by specifying a percentage for separation. You can define several entries to be included on your chart.

Specify a legend (description) for the entry, and specify the data field from quantity fields or user-defined data (integer and decimal type fields). Outline codes, reference fields, and user-defined text and flag fields can stack data. If you stack your data, you can click the Stack Groups button to select the colour and shading for each element.

SP%20BE%20Histogram%20Periodic%20Entries

Fields and buttonsDescription
NameEnter a text to name the periodic entry.
LegendEnter a text to describe the periodic entry.
Data FieldSelect the data field from the drop-down list.
Stacked BySelect the data field to stack by.
Weight OnIt is only available if you specify the field value to be per cent on the right axis tab. Using the 'weight on,' you can specify what field holds the value that should be used as the 100%—if it is other than the selected data field. Your data field will then be weighed against this field to determine the periodic percentage for each period.
From DateSelect the start date from the drop-down list.
Until DateSelect the finish date from the drop-down list.
Graph TypeSelect Histogram, Line Graph, or Profile from the drop-down list.
SeparationThis option is only available if the selected Graph type is a Histogram. It can be used if you want to have some space between the columns in the histogram, given in %.
Stacking – Include NoneThe checkbox is available when the histogram is displayed as stacked. When the checkbox is ticked, the activities that do not have values in the field used for stacking will be shown as a single group called None.
Stack Groups…This will open the Stack Groups window to change the colour and hatching.
Values – Font – DecTicked checkbox will give the total value on top of each column. Select a font type, size, colour, bold, italics, and underlined for the value displayed. In the Dec spinner box, you can select how many numbers you want to display after the decimal point.
ColourSelect the colour for the graph from the drop-down list. This only applies if Stacked By is not used (if Stacked By is used,) then change the colour in Stack Groups…).
PatternSelect the pattern type for the histogram from the drop-down list. This option is available when the selected Graph type is Histogram and Stacked By is not used.
Pattern ColourSelect the pattern colour for the histogram from the drop-down list. Open when the graph type chosen is a histogram and Stacked By is not used.
Line StyleAvailable when the Graph type is Line Graph or Profile Select style from the drop-down list.
Line ThicknessAvailable when the Graph type is Line Graph or Profile. Enter or select a thickness from the spinner.
Limit From DateIt can show the Histogram/Profile/Line Graph for a certain period. Add or select a date from the drop-down list for the period.
Limit Until DateAdd or choose a date from the drop-down list for the period.
Value FactorSelect None, Thousands, or Millions from the drop-down list.
Stack LegendLegend will show either Short Description or Short + Description for stacked values.
Move Up/Move DownUse these two buttons to select an item in the Periodic entries list and move it up or down in the list.
NewAdds a new row to the periodic entries list.
DeleteDeletes a row in the Periodic entries list.

Cumulative Entries tab

Cumulative lines or curves show accumulated use for cost, budget, earned value, or other user-defined data. Select the Cumulative Entries tab; then, you can give the entries your description and legend, select the data field, select from and until date fields to spread or summarise data across and specify graph type as a Line graph.

SP%20BE%20Histogram%20Cumulative%20Entries

Fields and buttonsDescription
NameEnter a text to name the cumulative entry.
LegendEnter a text to describe the cumulative entry.
Data FieldSelect the data field from the drop-down list.
Spread OnIf you select a field or a level of an outline code, Safran Planner will use this to perform multiple time-- aggregations to provide you with numerous s-curves on a single report sheet against one X-axis. This is a unique feature. You may use it to show curves for different project phases side by side. This can be valuable for evaluating and visualising how your project phases fit. Spread curves can be displayed for field value or percentage.
Weight OnIt is only available if you, on the right axis tab, specify the field value to be percent. Using the 'weight on,' you can specify what field holds the value that should be used as the 100% - if other than the selected data field. Your data field will then be weighed against this field to determine the cumulative percentage for each period.
From DateSelect the start date from the drop-down list.
Until DateSelect the finish date from the drop-down list.
Graph TypeSelect Histogram, Line Graph, or Profile from the drop-down list.
SeparationThis option is available if the selected Graph type is a Histogram. It can be used if you want to have some space between the columns in the histogram, given in %.
Values – Font - DecA ticked checkbox will provide the total value at the top of each column. Select a font type, size, colour, bold, italics, and underlined for the value displayed. Choose if the number should be shown as a decimal value.
ColourSelect the colour for the graph from the drop-down list.
PatternSelect the hatch type for the histogram from the drop-down list. Available when the selected Graph type is Histogram.
Pattern ColourSelect the pattern colour for the histogram from the drop-down list. Open when the selected Graph type is histogram.
Line StyleAvailable when the Graph type is Line Graph or Profile Select style from the drop-down list.
Line ThicknessAvailable when the Graph type is Line Graph or Profile. Enter or select a thickness from the spinner.
Limit From DateIt can show the Histogram/Profile/Line Graph for a certain period. Add or select a date from the drop-down list for the period.
Limit Until DateAdd or choose a date from the drop-down list for the period.
Value FactorSelect None, Thousands, or Millions from the drop-down list.
Stack LegendLegend will show either Short Description or Short + Description for stacked values.
Move Up/Move DownPlease select an item in the list and move it up or down the table entries list using these two buttons.
NewAdds a new row in the Cumulative entries.
DeleteDeletes a row in the Cumulative entries.

Table Entries tab

A new table entry is added by default for each periodic and cumulative entry you define. You can also include new user-defined table entries or delete entries from the table.

SP%20BE%20Histogram%20Table%20Entries

Fields and buttonsDescription
NameEnter a test to name the table entry.
LegendEnter a text to describe the table entry.
Data FieldSelect the data field from the drop-down list.
Spread OnIf the Per./Cum = Cumulative: If the Cumulative Entries are spread, then the field used for spread on is visible here. In the table, there will be one row per code. If the Per./Cum = Periodic: If the Periodic Entries are stacked, then the field used for Stacked By is visible here. In the table, there will be one row per code.
Weight OnIf the Cumulative Entries are weighed, the field used for 'weight on' is visible here.
From DateSelect the start date from the drop-down list.
Until DateSelect the finish date from the drop-down list.
Stacking – Include NoneThe checkbox is available when the histogram is displayed as stacked. When the checkbox is ticked, the activities that do not have values in the field used for stacking will be entered in the table as a group called None.
Values – Font - DecSelect a hatch type for the histogram from the drop-down list. Available when the selected Graph type is Histogram.
Data TypeSelect a data type from the drop-down list: Field Value, Manpower, or Percent.
Per./CumSelect Periodic or Cumulative from the drop-down list.
DecimalsSelect the number of decimals displayed in the table.
FactorSelect None, Thousands, or Millions from the drop-down list.
Factor TextIf the factor is different from 'None,' you can tick the checkbox, and the factor will be displayed in the right table for each row.
Limit From DateIt can show the Histogram/Profile/Line Graph for a certain period. Add or select a date from the drop-down list for the period.
Limit Until DateAdd or choose a date from the drop-down list for the period.
Spread LegendLegend will show either Short, Description, or Short + Description for stacked values.
Move Up/Move DownPlease select an item in the list and move it up or down the table entries list using these two buttons.
NewAdds a new row to the table entries list.
DeleteDeletes a row in the Table entries list.

Was this article helpful?