SOLVED
Home

Reversing the x-axis on a Combo chart (2 different y-axes) only flips the values for one of the two?

%3CLINGO-SUB%20id%3D%22lingo-sub-91179%22%20slang%3D%22en-US%22%3EReversing%20the%20x-axis%20on%20a%20Combo%20chart%20(2%20different%20y-axes)%20only%20flips%20the%20values%20for%20one%20of%20the%20two%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91179%22%20slang%3D%22en-US%22%3E%3CP%3EI%20will%20attach%20three%20images.%20The%20first%20is%20this%20combo%20chart%2C%20but%20as%20you%20can%20see%2C%20the%20months%20are%20in%20reverse%20chronological%20order.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20836px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F17858iC9DBD57222EDF03B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222017-07-28%2015_39_41-Book1%20-%20Microsoft%20Excel.png%22%20title%3D%222017-07-28%2015_39_41-Book1%20-%20Microsoft%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20attempting%20to%20flip%20all%20data%20by%20selecting%20the%20%22Categories%20in%20reverse%20order%22%20button%20in%20the%20formatting%20of%20the%20x-axis%20only%20flips%20%3CSTRONG%3Eone%3C%2FSTRONG%3E%26nbsp%3Bof%20the%20two%20datasets%2C%20and%20not%20both%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F17859i66A87C55D8766A92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222017-07-28%2015_39_53-Book1%20-%20Microsoft%20Excel.png%22%20title%3D%222017-07-28%2015_39_53-Book1%20-%20Microsoft%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20quite%20sure%20what%20I'm%20doing%20wrong%2C%20here.%20Googling%20hasn't%26nbsp%3Bhelped%20me.%3C%2FP%3E%3CP%3EMy%20dataset%20in%20question%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F17860iAE36499CA7E6FA92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222017-07-28%2015_43_09-Book1%20-%20Microsoft%20Excel.png%22%20title%3D%222017-07-28%2015_43_09-Book1%20-%20Microsoft%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-91179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91190%22%20slang%3D%22en-US%22%3ERe%3A%20Reversing%20the%20x-axis%20on%20a%20Combo%20chart%20(2%20different%20y-axes)%20only%20flips%20the%20values%20for%20one%20of%20the%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91190%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Robin%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20your%20initial%20graph%20after%20you%20added%20secondary%20vertical%20axis%20add%20secondary%20horizontal%20axis%2C%20it%20will%20repeat%20the%20primary%20one%20and%20will%20be%20on%20the%20top%20of%20the%20graph.%20After%20that%20select%20primary%20horizontal%20axis%2C%20reverse%20it.%20Next%20select%20secondary%20horizontal%20axis%2C%20reverse%20as%20well.%20Select%20secondary%20horizontal%20axis%20and%20delete%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Robin Bach
Occasional Visitor

I will attach three images. The first is this combo chart, but as you can see, the months are in reverse chronological order. 

 

2017-07-28 15_39_41-Book1 - Microsoft Excel.png

 

However, attempting to flip all data by selecting the "Categories in reverse order" button in the formatting of the x-axis only flips one of the two datasets, and not both:

 

2017-07-28 15_39_53-Book1 - Microsoft Excel.png

 

I'm not quite sure what I'm doing wrong, here. Googling hasn't helped me.

My dataset in question:

 

2017-07-28 15_43_09-Book1 - Microsoft Excel.png

1 Reply
Highlighted
Solution

Hi Robin,

 

On your initial graph after you added secondary vertical axis add secondary horizontal axis, it will repeat the primary one and will be on the top of the graph. After that select primary horizontal axis, reverse it. Next select secondary horizontal axis, reverse as well. Select secondary horizontal axis and delete it.

 

 

Related Conversations