Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Chart - Invert the Y (or Y2) axis (20.1)
Hi,
I have a combination chart with the SQL query at the region level
I have a Y2 axis for my league position series, 1st is best and represents the top of the league table so I would like 1 to be at the top of the axis, at the moment it is at the bottom
I've googled it and searched on here and everything about "invert" seems to relate to version 5.1 or earlier, can it be achieved in Apex 20.1? I can't find the setting
Thanks
(edited to make a simple clarification)
Best Answer
-
How about to replace your position values with negative ones (so 1 becomes -1 etc) and change labels to positive with custom y2 axis label converter See APEX 20.1 Sample Charts applications page 46 Event Drops to see how to add a custom converter. You may also need to change these properties as well: valueFormats.y2.converter and valueFormats.label.converter
Answers
-
How about to replace your position values with negative ones (so 1 becomes -1 etc) and change labels to positive with custom y2 axis label converter See APEX 20.1 Sample Charts applications page 46 Event Drops to see how to add a custom converter. You may also need to change these properties as well: valueFormats.y2.converter and valueFormats.label.converter
-
crikey, i was hoping it would be something simple like options.y2Invert = true
thank you, I'll have a play using your suggestions, i may have questions
did you alter my chart like that from dev tools console?
-
Keyser wrote:did you alter my chart like that from dev tools console?
No, I made a replica
-
and with the facility to download it so that I can copy your code and produce this...
and for teams that aren't quite as good...
that's exactly how i wanted it, thank you very much for your help, it's much appreciated!