Excel Chart Formatting

In the attached PivotChart, how can I format the x-axis such that the subheadings are not overlapping?

Bonus question: how to get rid of "blank"?

MV
Chart-Example.xlsx
LVL 11
Michael VasilevskySolutions ArchitectAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
FlysterConnect With a Mentor Commented:
Still working on the overlapping, but I'll go for the bonus question. Go to Row 18. To the right of Row Labels is a filter tab. Click the tab, go down to (Blank) and uncheck it.

Flyster
0
 
FlysterConnect With a Mentor Commented:
See if this is what you wanted. I right-clicked the chart and selected Show Field List. This brought up the Pivottable Field List. FSE was then unchecked.
Chart-Example.xlsx
0
 
Michael VasilevskySolutions ArchitectAuthor Commented:
I need to see both FSE and task, since just task is not unique. I like how it was formatted originally, except that there is overlap of FSE names. If I could angle the labels or something to avoid overlap...
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.