Grouped Bar with Line Graph
Intro
A standard Grouped Bar with Line graph is a combination of a Line graph and a vertical Bar graph. It includes two yaxes, one on each side of the graph. One of these is used to measure the values along the line, and the other is used to measure the values of the bars. A Grouped Bar with Line graph is similar to a Stacked Bar with Line graph, the difference being that in a Grouped Bar with Line graph, series are represented as vertical bars laid out side by side in their respective categories, whereas in a Stacked Bar with Line graph, series are stacked on top of each other in their categories.
The Grouped Bar with Line graph has a number of subtype graphs:

Vertical Grouped Bar with Symbols

Vertical Grouped Bar with Curved Line

Vertical Line with Grouped Bar

Horizontal Grouped Bar with Line

Horizontal Grouped Bar with Symbols

Horizontal Grouped Bar with Curved Line

Line with Grouped Bar (called "Grouped Bar + Line" in the user interface instead of the usual "Line + Grouped Bar")
For descriptions and screenshots of all these graph types, see Available Bar Graphs.
Powering Grouped Bar with Line graphs
Grouped Bar with Line graphs require three columns or rows of data from your DataSet—one for series, one for categories, and one for values. For information about value, category, and series data, see Understanding Chart Data.
In the Analyzer, you choose the columns containing the data for your Grouped Bar with Line graph. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.
For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.
The following graphic shows you how data from a typical columnbased spreadsheet is converted into a Grouped Bar with Line graph:
Customizing Grouped Bar with Line graphs
You can customize the appearance of a Grouped Bar with Line graph by editing its Chart Properties and by changing the sorting, scale syncing, and number formatting.
Chart properties
Unique properties of Grouped Bar with Line graphs include the following. You can click a thumbnail image to see a larger image.
For information about all chart properties, see Chart Properties.
Property 
Description 
Example 

General > Starting Symbol 
Lets you select the symbol used to represent the first line in all symbolbar combination charts. (The default symbol is a triangle.) If more than one symbol series appears, the chart rotates through symbols in this order: Triangle, Circle, Plus, Square, Diamond. For example, if your chart had four symbol series and you selected Plus for the starting symbol, the first series would be represented using plus signs, the second with squares, the third with diamonds, and the fourth with triangles. In the example at right, circles, pluses, and squares are used. 

General > Series on Top Scale  Refers to the number of lines and bars in horizontal linebar combination graphs By default, the first series that appears in your legend for these chart types becomes a line, and all remaining series become bars. However, you can convert series from bars to lines by entering the desired number of lines here. For example, if your chart had three series, the first series appearing in your legend would appear as a line, and the remaining two series would appear as bars. You could turn the second series into a line by entering 2 in the Series on Top Scale field. 
— 
General > Series on Left Scale 
Determines how many series in your graph appear as lines (or symbol series in a Symbol Bar graph). By default, the first series that appears in your legend for these chart types becomes a line, and all remaining series become bars. However, you can convert series from bars to lines by entering the desired number of lines in Chart Properties. For example, if your chart had three series, the first series appearing in your legend would appear as a line, and the remaining two series would appear as bars. You could turn the second series into a line by entering 2 in the Series on Left Scale field. Note: Symbols are autoselected based on the series. You cannot assign a specific symbol to a given series

— 
General > Line Style 
Lets you change the line style in your graph. By default, lines in linebar combination graphs appear angular. If you want, you can change the line style to be curved. The example shows a chart in which the line style has been set to Curved. 

General > Sync Value Scales 
Determines whether value scales in dualscale graphs are synced. For more information, see Syncing Value Scales in a DualScale Graph. The example shows a chart with synced value scales. 

General > Hide Second Scale 
Hides the second value scale in dualscale graphs in which you have synced the scales using the Sync Value Scales option. For more information, see Syncing Value Scales in a DualScale Graph. 
— 
General > Number of Running Total Lines 
Lets you specify the number of lines in linebar combination charts that are running total lines. Lines that become running total lines are determined by your chart series order as it appears in your legend. For example, if you indicated that you wanted two running total lines, the lines corresponding to the first two line series in your legend would become running total lines. In the example, the blue and light green lines are running total lines; the dark green line is not. 

General > Number of Running Total Bars 
Lets you specify the number of bars in linebar combination charts that are running total bars. Bars that become running total bars are determined by your chart series order as it appears in your legend. For example, if you indicated that you wanted two running total bars, the bars corresponding to the first two bar series in your legend would become running total bars. In the example, the light and dark green bars are running total bars; the other bars are not. 

General > Sync Zero Lines 
Syncs the zero lines in dualscale graphs with negative values so the "0" values match. The first example at right shows a dualscale graph with scales that do not match. The rightside graph is being used to measure sales, which are always going to be positive; hence the scale starts at 0. However, the leftside scale is being used to measure profit, which may dip below 0. In this case the scale starts at 2000. Because the scales do not match, the graph is difficult to interpret. The second example shows the same graph with the zero lines synced. Even though the other values do not match, the viewer can easily use the zero line as a reference point to interpret the line and bars simultaneously. 

Last Bar/Line Value Projection > Project Using 
Determines whether a final value is projected for bars or lines in a Grouped Bar with Line graph and, if so, how this value is determined. You can enter a specific value for a projection or set Domo to project a value automatically either by taking the average of the previous points in the graph or by using a linear regression. Two examples of Grouped Bar with Line graphs are shown at right. In the first, the final value for the bars has been projected using the average of the four previous values. In the second, the final value for the lines has been projected using a specified value. For more information, see Projecting the Last Value in Your Chart. 

Data Label Settings > Show Data Labels On 
Determines whether data labels appear for lines, bars, or both. 
— 
Sorting
You can manipulate which series becomes lines and bars in a Grouped Bar with Line graph by changing the series order in your legend. By default, the sort method is set to No Sorting, which arranges your series in alphabetical order. For most charts with both lines and bars, this is not the optimal sort method. For the best results, do the following:

Ensure that the series that should correspond to the line appears first in your DataSet, and

choose an itembased sorting method, either ascending or descending.
Because itembased sorting sorts the items in the DataSet alphabetically by category, with the series items in each category appearing in the same order that they appear in the spreadsheet, the first series in your DataSet becomes the line. For more information about sorting, see Sorting the Data in Your Chart.
Syncing value scales
By default, the two value scales in a Grouped Bar with Line graph are matched to the data they measure, not to each other. For example, the values for your line might range from 0 to 100, and the values for your bars might range from 2 to 12. You can sync the scales by checking Sync Value Scales in Chart Properties. For more information, see Syncing Value Scales in a DualScale Graph.
Changing scale formatting
It is possible to have separate number formatting for both vertical axes in a Grouped Bar with Line graph. For example, you could have percent symbols affixed to the values in one axis and currency symbols affixed to the values in the other. You can do this in the Format menus or the Chart Properties. Domo recommends that you use Chart Properties to make formatting changes, not the Format menus, because the options in the Format menus are overridden by formatting changes in Chart Properties. For more information about formatting values, see Formatting Values in Your Chart.