Forum Discussion
Solved
combo chart with Secondary axis shows the data in wrong order
Hi, I m working on the 365 version.
I have the following data:
when I create a combo chart, notice that the data marked as secondary axis (the line chart), is shown in reverse order (1-Jan is supposed to be 2,907 and it is shown 3,174 (see the picture below)
I need the x-axis to be the same as the picture shows (right to left).
how can I fix?
The line chart uses the original order of the x-values.
On the Chart Design tab of the ribbon, in the Chart Layouts group, select Add Chart Element > Axes > Secondary Horizontal.
Doube-click the new secondary x-axis, and under Axis Options in the Format Axis task pane, tick the check box 'Categories in reverse order'.
The line chart uses the original order of the x-values.
On the Chart Design tab of the ribbon, in the Chart Layouts group, select Add Chart Element > Axes > Secondary Horizontal.
Doube-click the new secondary x-axis, and under Axis Options in the Format Axis task pane, tick the check box 'Categories in reverse order'.
- Thanks, it solved the problem.
