tanrisev1
asked on
Number of groups between labels
Hi everybody,
I am trying chart a huge amount of data with crystal reports so it is important that not every label of the x-axis is visible.
Does anyone know a solution for this?
I know I can use the "manual number of groups between labels" option in chart properties. But this option lets me enter a number only up to 3!
But, I need more than 3 spaces between the group labels.
I am trying chart a huge amount of data with crystal reports so it is important that not every label of the x-axis is visible.
Does anyone know a solution for this?
I know I can use the "manual number of groups between labels" option in chart properties. But this option lets me enter a number only up to 3!
But, I need more than 3 spaces between the group labels.
You can also try using the AutoArrange menu item and have CR automatically pick a nice 'skip' factor for you.
If that doesn't work, you can also try our CRChart replacement library which has an @XSKIP macro that lets you set the skip to whatever value you like [Disclaimer: This product costs money. I work for the company that makes this product. There may be other better/cheaper solutions out there that I do not know about].
-Dan @ 3D
If that doesn't work, you can also try our CRChart replacement library which has an @XSKIP macro that lets you set the skip to whatever value you like [Disclaimer: This product costs money. I work for the company that makes this product. There may be other better/cheaper solutions out there that I do not know about].
-Dan @ 3D
ASKER
Hi Dan3D,
I couldn't find the AutoArrange menu item. Let me clarify some points. I am using Visual Studio.NET and the crystal report package that is delivered with .NET for my charts. Please give me some more information about how I may find this AutoArrange item. There is no such item in my menus. I do desperately need a solution for my labels. I have hundreds of labels on top of each other on my chart.
Thanks,
I couldn't find the AutoArrange menu item. Let me clarify some points. I am using Visual Studio.NET and the crystal report package that is delivered with .NET for my charts. Please give me some more information about how I may find this AutoArrange item. There is no such item in my menus. I do desperately need a solution for my labels. I have hundreds of labels on top of each other on my chart.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In some cases what I've been able to do is to hide the x-axis labels on the chart completely and manually position text fields below the chart to label the axis. If the x-axis is going to change then this won't work - it's only usefull for charts that always show a fixed number of entries on the x-axis.
For charts w/ dynamic number of entries the best (which isn't good) approach I've found is to use a formula to shorten the labels used on the chart and then create a key elsewhere on the report to cross-reference the entries. I freely admit this is a horrible workaround and not likely to satisfy most cases but there isn't much else you can do...