Pivot Chart - X Axis issues

[Mustafa Evans]

Hi all, hope you can help me, i have some data that i've created a pivot table and pivot chart for. The chart needs to show locations of patients with various Learning Difficulties. I have managed to the all of this, except for the x axis has an issue with the labels over writing each other.

The only was so far i can achieve a solution is to increase the size of the chart which then makes it too big. Am hoping to get a solution to "word wrap" the labels maybe.

The red arrow points to the issue i'm having.

The chart shows that there are a number of Dyslexia patients in "CSU, D, G, H, L & M" etc.

Hope you (someone) will be able to help me.

Many thanks in advance.

 

[denzo36]

You could try and rotate the text by 45 degrees or 90 degrees so they fit it or you could reduce the font size?

 

[RoryA]

Or perhaps make the Condition field show items with no data

 

[Mustafa Evans]

I need both as I am using multi level category labels.

Looking at the Alignment of the X Axis, the lower half is greyed out and may be a means to resolve my problem. I have tried reducing font and using the custom angle, but both only affect the "Location" data and not the Ailments data.

Any ideas .... Please

 

[denzo36]

You will have to select the 'Ailments' labels on the x-axis on the chart first, then hit CTRL+1 to open the format axis box - from here use the 'text layout' to move your labels around. You can also reduce the font size like you would normal font once you've selected the correct labels you want to edit

 

[denzo36]

Maybe not possible actually now that I've tried it myself, apologies - I'm not sure it is possible

 

[Mustafa Evans]

The multi level x axis are all bundled in the same selection and i can't see how to separate them, i can only seem to manipulate the location data only.

Can you point me to the "text layout" as i couldn't find that. Many thanks.

 

[RoryA]

If you select the option to show items with no data, you'd have more room for the text since there would be gaps for CSU, D, G, H, L and N in all the conditions.