Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my bar chart i want to show the totals by month wise (12 months) but my chart is having huge monthly count, suppose for some moths the count is 30000+ for some months count is <=1000, if i will show the count as it is look and feel of the chart is not good, see the attached screen shot,
Here what am trying is suppose if one bar is having 35678 then i trying to show the count is 35K like for this am using the below expression
=count(if((C_TCKT_STAT='C'),I_TCKT))/1000 //&'K' but it is not giving correct result,, is there any other way to acheive this ? |
I can enlarge the chart but we have the specfic req for layout of the chart,,, what is the alternate way to do for this?
Regards,
Anil
Hi,
Try below settings and see hw it looks.
Go to properties of chart -> Axes -> Select the expression -> check Log Scale.
Regards,
Kaushik Solanki
Hi Kaushik
Thnx for your replay i have tried the above settings but it is not giving good result again.
Regards,
Anil
On the 'Presentation tab' you could make the 'Values on Data Points' - Vertical.
Hi Anil,
Try this,
Presentaion Tab - > select CalendarMonthAndYear.
check the box Max visible Number (1-100), in the text box enter a value 06.
and check the below box show X-AxisScrollbar.
APPLy and click on ok.
Scroll bar will be added in X-Axis, user can use scroll bar to see all the value.
you can reduce the size of the scroll bar in Layout tab , scroll width to 3
check this whether this solution suits you.
regards,
sam
Sam and beanz thnx for your replies,
Sam this is some what good, but in one look if user want to compare the count between months he has move the scroll bar front and back in this case it is not good look and feel of the chart am i right??
Is there any other way for this??
Regards,
Anil