Bob Abrams
Member
Members
Forum Posts: 17
Member Since:
October 14, 2015
October 14, 2015
Offline
I have attached a workbook with two samples from a series of daily charts I'm preparing. I want the legend entry for the series with the greatest value to be on top.
In the chart on the left, M2 is greater than M1, but the legend entries show M1 on top (as it's the first series charted).
In the chart on the right, M1 is greater than M2, and the legend shows M1 on top, as I want.
I know that I can manually fix the chart on the left by changing the sequence of the series, but I need a way to have this happen automatically, as some days will have M2>M1, and others will have M1>M2.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Kathleen Silva, Alex Dawson, Kang-Ting Lee, Karla de Visser
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33706
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —