ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data series and LegendEntries order reversed in clustered bar chart (https://www.excelbanter.com/excel-programming/346450-data-series-legendentries-order-reversed-clustered-bar-chart.html)

[email protected]

Data series and LegendEntries order reversed in clustered bar chart
 
Hi,

I have a simple table with 2 data series (in rows):

item
X 10
Y 20

When inserted as a clustered bar chart, the "Y" bar is on top of the
"X" bar as it should. However the legend seems to behave differently.
When the legend is placed on the right/left, "Y" is listed on top of
"X" as it should. But when placed on the top/bottom, "X" shows on the
left and "Y" on the right. Since we read English from left to right,
wouldn't it make more sense that "Y" be on the left(read first)?

Say, regardless what makes more sense and the client requests "Y" be
listed on the left, is there a way to reverse the order of
LegendEntries but not the data series?

Thanks in advance,
WH



All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com