Forum Discussion
Bar chart Data Labels in reverse order
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.
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.
I want to build a diagram using the numbers in a column, in REVERSE order. Isn't that possible?