• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

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
0
Michael Vasilevsky
Asked:
Michael Vasilevsky
  • 2
2 Solutions
 
FlysterCommented:
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
 
FlysterCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now