APEX

Have you check that property?

Jabbamp wrote:
Hi there all. Although I am getting better at this, there are still so many mysteries I have search answers for and cannot find them anywhere.
I am using Apex 5.1.4. Below is a bar chart region. For lack of something that could do the job better, I am using this as a kind of indicator. 

Instead of asking XY questions about a solution that you are not happy with, it would be a better use of both your time and ours if you described the problem that you are actually trying to solve. What "kind of indicator" would you really like to see? Give us some background about the environment, problem domain, and application, and describe the requirements (and any restrictions) in detail.

It used to be a column which is not used anymore so instead I am using barchart.

I have no idea what that means. If it is relevant to the problem, please try to explain this more clearly.

Thank you, absolutely perfect. Also to add that because of you pointing me to this answer I managed to find where I could see all the classes here https://docs.oracle.com/middleware/jet202/jet/reference-jet/oj.ojChart.html#xAxis.titleStyle . As a complete noob his has been a big valuable piece of help. Thanks again

Hi, yes I did, but it didn't do what I needed. But thank you for replying.

Hi fac586. I understand what you are saying, but I really just needed exactly what I asked for. The problem I was trying to solve was just to reduce the bar height. The rest has been made by a developer earlier and I don't have any say in the query. The solution he had was made on 4.2 and I have just been working with the migration to 5.1.4. It just needed to look close to what it was before using the new Jet Charts, not really my choice. So that was the exact problem I was trying to solve - just very basically to reduce the bar height and keep the full labels showing.

Ignore the statement about the column. I just saw that the method used in the old 4.2 application was with a stacked 2d column. I was trying to explain that and basically failed in this respect. So I just wanted to basically get the same look.

If I go further and start actually developing new reports at some point and need help, I would certainly detail the scenario much more fully. I appreciate the tips though and will for sure take that into consideration in the future.

Hi, Rather that use custom javascript, I will use a build-in functionality. The minimum, maximum, format type and decimal places in the bar chart property do what you need. Just use it good

Hiya Alli,

I did try to use these, but the hight of the bar would not go any lower. I set the lowest values. The only way to decrease the bar height was to reduce the region, but then the labels on x axis would cut cut off as shown in the images in the original post. Using the javascript worked perfectly though.

Can you reproduce it on online apex?

Hi There Alli,

Unfortunately I have moved on from the company I was doing the work for and am starting something else with another company so will be working with PHP and MySql going forward. I do not have access to the work now and also unfortunately will not be working with Apex for the meanwhile at least.

But basically, in the attributes of the bar chart, I just put this code into the Advanced attributes in the JavaScript code:

function( options ) //takes options

{   

  options.xAxis.size  = "80%" //size in %

  options.styleDefaults.barGapRatio = 0; //gap between bars

  return options;  //return set options

} 

All the classes for the charts can be found here: -

https://docs.oracle.com/middleware/jet202/jet/reference-jet/oj.ojChart.html#xAxis.titleStyle

Don't know if that's helpful to you. I hope at some point I'll return to using Apex as I thinks its a very good product.