6.6.5 Grouped Column with Error Bars and Data Labels


Video Image.png Video Text Image.png Website blog icon circle.png Blog Image 33x33px.png

Summary

Origin supports grouped column graphs with indexed data. Multiple group levels are supported. Grouping information can be shown in tick label tables on the X or Y axes.

Grouped Column with Error Bars and Data Labels 13.png

What will you learn

This tutorial will show you how to

  • Plot grouped column and error bar with indexed data
  • Customize tick labels, colors, gaps, error bars and data labels
  • Update legend to show grouping information.

Steps

  1. Select Help: Learning Center menu or press F11 key to open the Learning Center, and then select Graph Sample in left panel and select the category "Column and Bar Charts", find this graph and double-click on it to open this sample. Grouped Column with Error Bars and Data Labels 01.png
  2. We are going to create a grouped column chart from the worksheet "Weekly Data". Highlight column D(Y2) and E(yErr) and select Plot > Categorical : Grouped Columns - Indexed Data... from the main menu.
  3. In plot_gindexed dialog, click Button Arrow.png in the "Group Column(s)" to add columns B, C, and F (in that order) to the Group List. Click the OK button.
    Grouped Column with Error Bars and Data Labels grouplist.png
    A grouped column plot with error bar is created. The 3-row tick label table at the bottom shows the grouping information. Note that a worksheet is created to contain the data used to create this graph.
    Grouped Column with Error Bars and Data Labels default.png
  4. To hide the first tick label row, double-click on any tick label in the row, e.g. EC2. The Axis dialog box will open with the Bottom 3 icon selected in the left panel. uncheck the Show box and click Apply.
    Grouped Column with Error Bars and Data Labels bottom3.png
  5. We want to customize the appearance of the Bottom 2 tick label row. Select the Bottom 2 icon on the left panel. On the Table tab, clear the Auto box, clear all Border check boxes then click the OK button.
    Grouped Column with Error Bars and Data Labels 08.png
    Two tick label rows remain, each with different layout.
    Grouped Column with Error Bars and Data Labels axis.png

Further Customizations

The tutorial steps that follow, further customize the graph so that it looks like the image in the Summary section.

  1. Click on the left Y axis in the graph, and in the popup mini toolbar, click the Show Gridlines button Popup Axis Show Gridlines.png to select Major from the drop-down list to add major grad lines for the graph.
    Grouped Column with Error Bars and Data Labels grids.png
  2. Click on any error bar in the graph, and in the popup mini toolbar, click the Direction button Popup Error Bar Direction.png to select Plus Y Error from the list to just show the plus Y errors.
    Grouped Column with Error Bars and Data Labels 07.png
  3. Click on any column in the graph, and in the popup mini toolbar, click the Show Data Labels button Popup Scatter Show Data Labels.png to show the labels at the top of the error bars.
    Grouped Column with Error Bars and Data Labels 06.png
    Click on any label, and in the popup mini toolbar, set Font Size to "16".
    Grouped Column with Error Bars and Data Labels 06 01.png

    To format the label values, you can double-click on the labels to open the Labels tab of Plot Details dialog to set the Numeric Display Format drop-down list.

    For instance, to show a single decimal place for each label, enter ".1", then click OK. For more information, see Custom Numeric Formats

  4. Double-click on the columns to open the Plot Details dialog. To adjust the gap between each week, go to the Spacing tab and set the Gap Between Subsets(%) to 15 (hint: you can type into the box).
    Grouped Column with Error Bars and Data Labels 03.png
  5. We are going to use the data in column C to set fill pattern and add a color gradient fill to the column plot. Go to the Pattern tab of Plot Details and set as follows.
    To set fill Color to White, click the drop-down, click the Single tab and click the White cell. Similarly, for fill Pattern, click the drop-down, click the By Points tab, click the Use Column Values button and choose Col(C) from the list. The gradient fill direction should be Horizontal Center Out.
    Grouped Column with Error Bars and Data Labels gradient.png
  6. To customize the pattern list, click on the Pattern drop-down list again and then click the pencil icon to the right of the pattern list. This opens the Increment Editor, where you create your custom pattern list. Rearrange the top three entries in your custom list as shown, by dragging the numbered buttons to the left side of the pattern gallery.
    Grouped Column with Error Bars and Data Labels 05.png
  7. To change the graph page background color, select the Graph icon in the left panel of the Plot Details dialog box. Go to the Display tab and set color to LT Gray.
    Grouped Column with Error Bars and Data Labels bkground.png
  8. To change layer background color to white, select Layer1 node on left panel of the Plot Details dialog. Go to the Background tab and set Color to White. Click OK to close Plot Details.
    Grouped Column with Error Bars and Data Labels 11.png
  9. To show pattern information in the legend, right click the legend and choose Legend: Reconstruct Legend to show all categories.
  10. To arrange the legend horizontally, select the legend, press the CTRL key and drag one of the green handles along the sides of the legend until the legend entries are arranged in a horizontal fashion.
    Grouped Column with Error Bars and Data Labels dragLegend.png
    You can also right-click on the legend to select Legend: Arrange in Vertical/Arrange in Horizontal from the context menu to rearrange the legend items.
  11. Drag the legend to an appropriate position. Select and press Delete to remove the Y axis title.
    Grouped Column with Error Bars and Data Labels finalGraph.png

    To center and adjust margins on a finished graph, click on the graph to activate it, then choose Graph: Fit Layers to Page. Enter your Margin and determine whether to Maintain Layer Aspect Ratios, then click OK.