Handling long labels on X-Axis by wrapping and scaling


Author
Message
Alan Schofield
Alan Schofield
Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)
Group: Forum Members
Posts: 15, Visits: 1
Hi,

I'm evaluating Nevron Chart for SSRS and so far I'm progressing nicely. However... (there's always one of those isn't there!)

I have a grouped column chart (vertical bar, clustered). Depending on the data it can contain as many as 20 groups, each of 3 series (so 60 columns in all).

The problem is that some of the Category labels are long (around 30 characters sometimes). I set them to resolve by rotating 90 degrees which works fine but then they take up that much room vertically that the account for 50% of the entire chart.

Ideally I would like to set a maximum size (width, height, length or whatever) for the labels and then have them wrap if that size is exceeded as there is plenty of space available between each of the labels.

I've attached a screen shot of the current state.

I'm not sure if this is possible but you don't know if you don't ask I guess!

Regards,
Al.


Attachments
LongXAxislabels.png (761 views, 29.00 KB)
Reply
Alan Schofield
Alan Schofield
Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)
Group: Forum Members
Posts: 15, Visits: 1

Hi,

I've now created the chart from scratch and I can see a difference, however, I still cannot configure it as I would like. The text seems to get jumbled and looks as if the maximum width (or height as it's rotated) is not large enough. Changing the value of the Max Label Width does not appear to have any effect.

I've created a simple report project in VS2008 and created a small access database containing some sample data that shows this issue.

I've left almost everything as default. I simply dropped the chart onto the report and resized it. Note the report dimension default to centimetres, not inches. I doubt this will make any difference but you never know!

I then dropped the value field to the values section at the top of the chart control, the supercategory field onto the category section at the bottom of the chart control and the perioddesc field onto the series section on the right of the chart control.

I then set the Primary X Axis to Range, set the resolve mode to wrap and then played with various Max Width settings as per your instruction in your first response on this thread.

I've attached the entire solution which includes the database, you may need to change the connection string to point to the correct path but other than that, it should work OK. There is no security on the database to SSRS credentials on the data source can be set to "No Credentials".

It might be that I've simply not configured the chart correctly so hopefully you can point me in the right direction.

Regards,

Al.


Attachments
NevronWrappingIssueSample.zip (431 views, 28.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search