Chapter 17 · 17.14
A chart with columns and a line on a second axis
You want to show monthly revenue and the number of orders in one chart. But revenue runs into thousands of euros and orders into hundreds. In a normal chart, the order line ends up as a flat stripe at the bottom. The solution is a second vertical axis with its own scale. In Euro-Office, you do this with a combo chart.
As an example, we use the monthly figures of Bloemisterij Het Zonnetje: the month in A, revenue in B and the number of orders in C.
Step by step
- Select the data including the header row: A1:C13.
- On the Insert tab, click the arrow below Chart.
- At the bottom, in the Combo group, choose the first image: Clustered column - line on secondary axis. Hover over the images to see their names.

Revenue appears as columns and the number of orders as a line, each with its own scale: euros from 0 to 18,000 and quantities from 0 to 250. Both are now easy to read.

Note how Euro-Office draws the axes: both vertical axes sit side by side on the left, the outer one with the quantities and the inner one with the euros. The months also appear twice below the chart. So give the chart clear axis titles, so readers know which axis belongs to which series.
Updating and adjusting
- Click the chart. The chart settings appear on the right, with Change type, Select data and Switch Row/Column.
- You can adjust titles, axes and the legend via Show advanced settings, at the bottom of the same settings.
- Let both axes start at 0. If an axis starts higher, fluctuations look bigger than they are.
Pitfalls
- No second axis available in a normal line or column chart: in Euro-Office, the second axis only exists in combo charts. Choose a type from the Combo group.
- Only the revenue column selected: a combo chart needs at least two series of numbers. Select both columns.
