SOLVED
Home

Bar chart Data Labels in reverse order

%3CLINGO-SUB%20id%3D%22lingo-sub-312581%22%20slang%3D%22en-US%22%3EBar%20chart%20Data%20Labels%20in%20reverse%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312581%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20a%20problem%20with%20the%20way%20data%20labels%20are%20ordered%20when%20displayed%20in%20a%20bar%20chart.%26nbsp%3B%20Please%20see%20the%20attached%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENotice%20how%20the%20dates%26nbsp%3Bdescend%20in%20the%20table%20but%26nbsp%3Bthe%20related%20data%20label%20is%20ascending%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20the%20first%20data%20point%3A%26nbsp%3B%3CSTRONG%3Eitem%201%3B%201-Nov-18%3B%2030%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShouldn't%20that%20be%3A%20%3CSTRONG%3Eitem%208%3B%26nbsp%3B%3C%2FSTRONG%3E%3CSTRONG%3E1-Nov-18%3B%2030%3F%3C%2FSTRONG%3E%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%20917px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65680i24F3202198882742%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20the%20format%20axis%20properties%2C%20I%20reversed%20the%20order%20and%20it%20only%20reverses%20the%20entire%20axis%2C%20with%20the%20data%20labels%20attached%20to%20it.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20212px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65681iA27733E0F5DAC635%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20no%20other%20option%20than%20to%20re-copy%20the%20entire%20Status%20column%20in%20reverse%20order....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBar%20chart%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20label%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312610%22%20slang%3D%22en-US%22%3ERe%3A%20Bar%20chart%20Data%20Labels%20in%20reverse%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312610%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyou're%20using%20labels%20via%20the%20%22Value%20from%20Cells%22%20setting.%20In%20this%20setting%20a%20range%20of%20cells%20is%20specified.%20The%20order%20in%20which%20the%20text%20appears%20in%20these%20cells%20is%20the%20order%20that%20the%20labels%20will%20be%20displayed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20cells%20from%20which%20the%20label%20values%20are%20taken%20are%20totally%20independent%20of%20the%20axis%20order.%20The%20first%20data%20item%20gets%20the%20first%20label.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20reverse%20the%20data%20order%20in%20the%20chart%2C%20you%20will%20need%20to%20build%20a%20corresponding%20list%20of%20labels.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20want%20to%20consider%20sorting%20your%20source%20data%20by%20the%20date%20column%20in%20ascending%20order%2C%20then%20you%20don't%20have%20to%20make%20any%20changes%20to%20the%20default%20chart%20axis%20settings.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
yaoza
Occasional Visitor

I'm having a problem with the way data labels are ordered when displayed in a bar chart.  Please see the attached excel file.

 

Notice how the dates descend in the table but the related data label is ascending?

 

For example, the first data point: item 1; 1-Nov-18; 30

 

Shouldn't that be: item 8; 1-Nov-18; 30?

 

Capture.JPG

On the format axis properties, I reversed the order and it only reverses the entire axis, with the data labels attached to it.

Capture.JPG

 

I see no other option than to re-copy the entire Status column in reverse order....

1 Reply
Solution

Hello,

 

you're using labels via the "Value from Cells" setting. In this setting a range of cells is specified. The order in which the text appears in these cells is the order that the labels will be displayed.

 

The cells from which the label values are taken are totally independent of the axis order. The first data item gets the first label.

 

If you want to reverse the data order in the chart, you will need to build a corresponding list of labels. 

 

You may want to consider sorting your source data by the date column in ascending order, then you don't have to make any changes to the default chart axis settings. 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies