64
Views
8
Comments
Regarding Column chart issue

I'm having issue in column chart. I have the hundreds of records in aggregate. I want to show this data in column chart.The data which is on x-axis is not showing label names. And also I'm unable to decrease the size of column width.

2021-09-06 15-09-53
Dorine Boudry
 
MVP

not much we can do for you if you don't share the oml.  or at the very least some screen prints of your data, your chart properties in service studio, and the result when you test

UserImage.jpg
Buddula Bhuvaneshwari

Hi Dorine Boudry 

 Above image is result. In between them label names are missing and data is dynamic .



2024-06-01 07-14-16
Vaishali Thakur

Hey @Bhuvaneshwari Reddy 


Maybe this post will help you click Here, on a column chart dealing with a large dataset a column chart can sometimes lead to issues with label visibility and column width. 

I'm not sure but you have to set the "Label Rotation" to a suitable angle (e.g., 45 degrees) on the "X-Axis" settings the properties of your column chart. 


thanks,

2021-09-06 15-09-53
Dorine Boudry
 
MVP

what version of charts are you using ?

2021-09-06 15-09-53
Dorine Boudry
 
MVP

as far as i can tell, the charts widget tries to show as many labels as possible given a certain minimum font size, too much is just too much.

The angle for most labels would probably be 90

but at some point you also have to ask yourself is a chart is the most suitable way of showing your data when there are so many datapoints.

Another option is to enclose your chart in a container with a width dependant on the number of datapoints, and enclose that in a scrollable container, but then it will not all be visible in one view, and your user will need to scroll horizontally (like the yellow chart in this image).

Dorine

UserImage.jpg
Buddula Bhuvaneshwari

Hi Dorine Boudry, 

I added the css class like

      overflow-x:auto;

      overflow-y:auto;

      overflow-x:scroll;

      overflow-y:scroll;


The above css I added to the class .Both ways I tried. But not working properly. I enclosed in container also inside that container i added the css. But its not working. Can you please give detailed explanation how you done enclose in container.

2021-09-06 15-09-53
Dorine Boudry
 
MVP

You need 2 containers, 1 to make your chart wide enough, another one around it to make it all scroll within the width of your screen.


the only thing about that css that is important, is the overflow-x : scroll

See attached oml,

Dorine

QDR_ManyDataPoints.oml
UserImage.jpg
Buddula Bhuvaneshwari

Hi Dorine Boudry, 

Thank you so much for helping out me. I have gone through the oml file.Its working now.

Regards

Bhuvaneshwari


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.