View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] haungw1@yahoo.com is offline
external usenet poster
 
Posts: 1
Default 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