Show bars side by side (double column chart) - Ninja

Show bars side by side (double column chart)

Posted by Andrew Z at Wednesday, January 30, 2008 | Permalink

Say you create a chart with two different axes comparing the temperature and precipitation for an area throughout the year. To emphasize the relationship between temperature and precipitation, you combine the data into one chart with two Y-axes. Before 2.4, it was only possible to accomplish this:

Chart before 2.4.0

Notice the bars overlap, but now in 2.4 it is possible to emphasize the distinction by placing the bars side by side:

Chart with the new 2.4.0 feature 'Show bars side by side'

How to use

  1. Create a column chart or a bar chart (typically in Calc) with two data series.
  2. Double click on the chart to enter chart mode.
  3. Single click on the second data series to select the data series. You should see one green dot in the middle of each bars of the series.
  4. Right click on any bar in the series.
  5. Choose Object Properties. Context menu for data series
  6. Click the Options tab.
  7. Set Align data series to to Secondary Y axis.
  8. Check the box Show bars side by side.
  9. screenshot: 2.4 Calc: Data Series dialog box: 'show bars side by side' is checked
  10. Click the OK button.

Competition and retraining does not save this option Show bars side by side in Microsoft Excel 97/2000/XP format. Also, in the Excel 2007 application, I could not find the same option: the limitation is Microsoft's. Bernard Liengme provides a long trick called double columns to accomplish the same goal.

Related articles