Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
For chart syles, why doesn't color order match series order? AMiller Charts and Charting in Excel 1 October 29th 09 12:02 AM
copy columns with order reversed Karra Excel Discussion (Misc queries) 1 December 11th 07 06:18 PM
How to reverse the order of bars in Bar Clustered chart? [email protected] Excel Discussion (Misc queries) 1 March 12th 07 07:42 AM
Values reversed with secondary series. Jim Moberg Charts and Charting in Excel 1 November 13th 06 06:23 PM
Chart data reversed. keeney1228 Charts and Charting in Excel 1 July 20th 06 04:54 PM


All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"