# Questions tagged [pivot-chart]

The pivot-chart tag has no usage guidance.

**1**

vote

**0**answers

20 views

### MS Excel Filter Chart Data Labels not updating with filter

I have a large table of data containing my x-axis data, a column of dates, a column of numbers, and a column of data labels. I have setup a pivot chart where the date is the filter and the data all ...

**1**

vote

**1**answer

39 views

### Combining categories in charts

How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"?
I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?

**1**

vote

**3**answers

384 views

### Excel chart formatting lost when Refresh All or individual Right Click on Data > Refresh

I have 4 pivot charts that rely on data that is refreshed from a connection.
When I click refresh all I lose all the formatting I set up (colours/borders/line and bar and 2nd axis choices)
I have ...

**0**

votes

**1**answer

49 views

### How to remove blanks from pivot chart in Excel 365?

I want to remove "(blanks)" from pivot charts in Excel 365. How do I do that?
I have data which contains blanks:
Hdr
"a"
"a"
<blank>
"b"
"c"
This leads to a pivot table like this:
Labels ...

**0**

votes

**0**answers

25 views

### PivotChart Expand/Collapse elements in the legend

I have a pivot chart (stacked bars) showing data about different Teams, grouped in Departments, evaluated over time (months/quarters/years).
I want to be able to see the data either of the single ...

**1**

vote

**0**answers

155 views

### Pivot chart losing format after refresh

I have hundreds of pivot charts and every time i refresh the data i keep losing my data labels on the charts. I'm interested if it's possible to not lose the data labels or for a way to apply my chart ...

**0**

votes

**0**answers

35 views

### Displaying chart legend as a list

I'm trying to find a way in pivot charts to display the legend as a list. Depending on the current month data sometimes there are more/less entries with different data which completely ruins my legend ...

**2**

votes

**1**answer

1k views

### Excel Pivot with percentage and count on bar graph

Is it possible to create a Pivot bar graph that Shows percentage and Count in the same bar? I only have Excel 2010
MWE:
Firm Product
1 Car
2 Ship
3 Car
4 Ship
5 Car
I can easily ...

**1**

vote

**2**answers

2k views

### How to make chart showing year over year, where fiscal year starts July?

Our fiscal year starts in July. I want to show year over year data as a chart below, but I want the month to start at July.
I created a Pivot Chart from the raw data.
I looked at More Sort Options ...

**1**

vote

**0**answers

61 views

### Show contiguous time periods without data in Libre Calc pivot table, pivot chart?

A minimal example: our table has sales in 2015, 2017, but not 2016.
Date Sales
01/02/15 $500
10/11/17 $1000
You make a Pivot Table:
Data > Pivot Table > Create
Row Fields: Date
Data ...

**0**

votes

**1**answer

3k views

### How to maintain pivot chart format after refresh?

As I created a pivot chart, I applied format to the chart, such as changing color of some series.
However, when clicking on refresh, the format goes back to the default colors.
How can I maintain ...

**1**

vote

**0**answers

118 views

### Student voting system in Excel: Combination Slicer and Histogram

I am trying to create an interactive chart with an Excel workbook (2016) to display the results of student voting. My workbook has several columns, but the two relevant here are "student name" and "...

**0**

votes

**1**answer

2k views

### Error bars in pivot graphs Excel

I have some data, in which a calculated probability is presented, it's standard deviation, and a couple of "settings" leading to the probability.
When I make a pivor-chart out of this, I can nicely ...

**0**

votes

**1**answer

689 views

### Plotting values instead of sums in a pivot chart

I have this pivot table:
The data is arranged according to the following hierarchy:
Line -> Machine -> Year -> Week (1 to 52)
For each week there is a value for Score (%), Execution (%), Duration (%...

**2**

votes

**1**answer

2k views

### How to remove a duplicate value on slicer in Excel

I am trying to build a pivot table to compare some data.
I first made a Excel sheet for my colleagues to enter their respective data, expecting that discrepancies when they enter the data, I used ...

**0**

votes

**1**answer

128 views

### Slicer only corresponds to table not my chart - Mac Excel 16

I have inserted a pivot table based on the data range I want to use. From there, I have selected the data in the table and inserted a chart. I then insert a slicer, but when I select the category it ...

**1**

vote

**1**answer

75 views

### Plot day to day execution time duration for list of items

I am having the below data
Items Date Start Time End time
App 1 10/27/2017 1:00 13:00
App 2 10/27/2017 14:00 15:00
App 3 10/27/2017 17:00 20:00
App 1 10/28/...

**1**

vote

**1**answer

121 views

### Excel Pivot chart - displaying values not in the source data

I have data from a feedback survey in an Excel spreadsheet. The questions are rated on your typical Likert scale.
1 Strongly disagree
2 Disagree
3 Neutral
4 Agree
5 Strongly agree
In the main ...

**1**

vote

**1**answer

135 views

### Pivot table pulling from another excel file not updating when the file is updated

I have two excel files. One has all the data that is entered by multiple people periodically thru out the day. The second one pulls data from the first file and then a pivot chart is created. If ...

**1**

vote

**0**answers

41 views

### Excel:can I simplify creation of following pivot table and chart somehow?

I have following table that lists all projects: ProjectId, DateCompleted.
I want to create a table/chart that shows a total of projects completed each year/month.
I used =TEXT(DateCompleted,"MMM") ...

**1**

vote

**1**answer

743 views

### Excel Chart - Automatically Adjust Scale of Secondary Axis

I have 3 pivot charts being controlled by a slicer that changes the week ending date. On the chart I have "Impressions" on the Primary Axis and "Clicks" on the secondary axis.
What I would like is ...

**0**

votes

**0**answers

558 views

### Pivot Chart made on Windows Excel not working on Mac

I've made a Pivot Table / Chart in Excel on Windows 10.
See screenshot below.
I've sent the Excel document to a person who opened it on a Mac (see photo below). When she opens the file on the Mac, ...

**0**

votes

**2**answers

3k views

### Disconnect link between copied charts in Excel

I created a Pivot Chart in Excel and added a filter.
I would like to create copies of the chart with different filter selected in each one.
But it seems there is a link between them, and when I change ...

**3**

votes

**1**answer

678 views

### Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?

I am working with data in groups in Excel. I currently have a pivot table and chart set up with:
Rows: symptom name grouped into one of four international severity grades
Columns: four datasets - ...

**2**

votes

**2**answers

1k views

### How to connect existing slicers to new pivot charts?

I had 6 existing slicers connected to 4 pivot charts. I created a new pivot pie chart and want to connect 5 of the 6 existing slicers to it but I can't do so. The only thing I can do is create 5 new ...

**1**

vote

**0**answers

30 views

### Delete time data labels with zero value from a bar chart?

I am looking to remove data labels with a time format h:mm with a value of zero automatically from my pivot bar chart. Is there any way I could do this? Here the example ->Pivot bar chart displaying 0:...

**0**

votes

**0**answers

49 views

### How can I automatically create a series of Pivotcharts based on a Pivottable in Excel?

How can I automate create a series of Pivot Charts where the axis remains constant, yet the legend field and values field ititerates down the field list for each chart?
Situation:
I have an excel ...

**0**

votes

**1**answer

351 views

### Excel 2013 - removing LegendEntry objects from a PivotChart Legend using VBA

I've got a PivotChart which typically shows 6-8 series out of a possible 15, many of which tend to be zero. So every time it refreshes, it has 15 series and the Legend only needs to list the series ...

**0**

votes

**1**answer

663 views

### treat row labels as number instead of text in Excel pivot chart

I have a pivot table showing how often a certain "speed" is found in the table.
row labels count of Id
1 31
2 29
3 39
4 66
...
77 2
90 1
92 ...

**0**

votes

**0**answers

578 views

### Hide secondary rows in pivot chart but keep shown in pivot table Excel 2016

I have a pivot table with a pivot chart that contains sets of two rows and a value field:
COUNTRY -- a primary
COMPANY -- a secondary
SALES -- a value field
When I collapse all the secondary rows ...

**1**

vote

**1**answer

815 views

### Excel Pivot Chart - Percentage of Rows Containing Yes

Okay so I have a simple named range we'll call "RangeX", the results of a survey we ran. I have 800 rows of data
In response to one of the questions we had 4 possible answers (multiple choices ...

**0**

votes

**2**answers

729 views

### Dynamic Selection from Multiple Value Fields in Excel Pivot Chart

Is there a method for dynamically choosing the value fields displayed in an Excel pivot chart?
E.g., Suppose I have the data below and produce a pivot table with multiple value fields. Each of those ...

**1**

vote

**0**answers

2k views

### Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...

**4**

votes

**1**answer

11k views

### Can I convert a list of names directly into a pie chart in Excel?

I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like:
Abrams
Abrams
Butler
Cromwell
Cromwell
...