Pivot Chart - X Axis issues

Mustafa Evans

New Member
Joined
Mar 18, 2010
Messages
35
Office Version
  1. 2010
Platform
  1. Windows
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.

1605269507939.png


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.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
126
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,807
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Or perhaps make the Condition field show items with no data
 

Mustafa Evans

New Member
Joined
Mar 18, 2010
Messages
35
Office Version
  1. 2010
Platform
  1. Windows
I need both as I am using multi level category labels.

1605280029112.png


1605280072478.png
1605280175128.png


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

Board Regular
Joined
Sep 22, 2019
Messages
126
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

Board Regular
Joined
Sep 22, 2019
Messages
126
Office Version
  1. 365
Platform
  1. Windows
Maybe not possible actually now that I've tried it myself, apologies - I'm not sure it is possible
 

Mustafa Evans

New Member
Joined
Mar 18, 2010
Messages
35
Office Version
  1. 2010
Platform
  1. Windows
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.

1605281696682.png
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,807
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,126
Messages
5,570,332
Members
412,319
Latest member
akshat1231
Top