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...
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.