Solved

Excel Chart Formatting

Posted on 2013-06-12
5
84 Views
Last Modified: 2014-05-19
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
Comment
Question by:Michael Vasilevsky
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
Comment Utility
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
 
LVL 22

Assisted Solution

by:Flyster
Flyster earned 500 total points
Comment Utility
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
 
LVL 10

Author Comment

by:Michael Vasilevsky
Comment Utility
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
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now