# Questions tagged [pivot-chart]

The pivot-chart tag has no usage guidance.

65
questions

**0**

votes

**0**answers

9 views

### Pivot Chart - space X-axis values evenly over a range

I have a number of completion values that range between 0% and 100%. I am using a Pivot Chart to represent these graphically, as shown below.
Is there any way I can get the x-axis values to space ...

**0**

votes

**0**answers

12 views

### Line in Combo Chart in Pivot Chart

I am using a pivot chart that has a combo graph. On there I have 5 sets of data, and using bars for 3 of those data sets and line for 2 of those sets. When I select only 1 of the 4 months on my ...

**0**

votes

**1**answer

52 views

### Format series of excel pivot chart based on series title

I have a non-stacked pivot bar chart that is showing two values (Sum of Planned Hours & Sum of Actual Hours) for a number of Series.
What I want to achieve is a formatting rule that if all the ...

**0**

votes

**0**answers

92 views

### Add a gridline to the main category in a Pivotchart

I have the data in this format
and need to generate a graph like this
I have used pivot chart option and am able to get the graph. The only problem is that I want to separate the dates visually. ...

**0**

votes

**0**answers

14 views

### PivotChart - Milestone baseline vs actual dates

Good afternoon,
I have an Excel data table with a large number of milestones listed. Against each there are baseline, forecast and actual dates.
I would like to chart these as 3 lines in Excel (...

**2**

votes

**1**answer

33 views

### Remove Line in Pivot Chart for Blanks

How do I get the forecast to not show the flat line in the past and also the actual to now show the flat line in the future?

**0**

votes

**1**answer

35 views

### Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships.
Date Started Date Ended Member Name
11/27/2019 12/19/2019 ...

**0**

votes

**0**answers

31 views

### Office365 Excel 2016. Windows 10. How to make Pivot Table Chart only list rows where a specific field in the table has data

As the title says. Here's some screenshots if I'm being to vague:
Below is the table of my data that I make a Pivot table out of
Table
And here is the Pivot Table:
Pivot table
Now as you can see, ...

**0**

votes

**0**answers

23 views

### Change Excel Slicer from “OR” to “AND”

I'm trying to graph the number of people who have a certain skill set, using a slicer. The problem that I'm running into is that the slicer tool, by default, will show me ALL of the records that ...

**0**

votes

**0**answers

21 views

### Pivotchart, Multi-level category labels. Remove primary/secondary label

I am trying to get my labels to show the data.
Before:
When I check off Multi-level Category Labels the dates are gone and the other values remain.
is there a way to remove the top labels and leave ...

**0**

votes

**0**answers

29 views

### How to add string data values below bar chart as custom data labels?

I have a large dataset with a data structure which can be reduced to basically two columns. One column contains text values, like "Name1" or "Thisisanothername". The other contains a category value, ...

**0**

votes

**0**answers

23 views

### Create a way for a layperson to query the data model in Excel

I have an Excel spreadsheet that is connected to an Access database through the Data Model. I have a Pivot Chart based on the data in said database.
The Pivot Chart is great for looking at subsets ...

**0**

votes

**0**answers

25 views

### How to analyse correlations in Ms Excel

Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this?
...

**0**

votes

**0**answers

36 views

### MS Excel. How to analyse dates when they are heading names?

I've been given a data set that consists of hundreds of Stores and almost a hundred dates, below is a small sample. The issue is that dates (mmm-yy) are actually heading names. The reason I see this ...

**0**

votes

**0**answers

38 views

### MS Excel. Slicer alternative when dealing with hundreds of values

I'd normally use a slicer but in this instance I have almost 300 options and a slicer won't be very user friendly.
Can someone please suggest an alternative?

**0**

votes

**0**answers

25 views

### MS Excel. Does it make sense to represent data in such a way?

I have a data set that looks something like this. At the moment, data is sorted by region, and at the end of each section there is a row for Region averages for all the months.
However, I'd like to ...

**0**

votes

**0**answers

18 views

### How to preserve pivot chart formatting? [duplicate]

Every time I make changes to my pivot table, the chart formatting reverts back to its original appearance. How do I preserve my chart formatting?

**0**

votes

**0**answers

9 views

### Slicer updating just one of the Pivot tables within same tab

I Have two pivot tables and a pivot chart in one tab. I've also created a series of slicers, all of which are updating the pivot chart and one of the pivot tables. However, one of the pivot tables isn'...

**0**

votes

**0**answers

5 views

### Microsoft Excel 2019 (365) custom colours won't stick on pivot chart

I made some modifications to my workbook which meant i had to reset the pie charts and now the colour blocks i selected to match similar charts on the same page will not stick. Every time i open or ...

**0**

votes

**0**answers

242 views

### How can I show multiple values for a row? (Excel Pivot Table)

As far as I am aware, the values in pivot table can only be shown as a sum, average, count etc. but not as a list of the raw values?
What I am looking for is to list all the times ran for each ...

**1**

vote

**1**answer

913 views

### Excel VBA: check if a chart series exists, if not continue

Each time a pivot chart is refreshed, it loses it's formatting. So I have a
piece of VBA code to re-format the graph each time the pages refreshes.
Private Sub Worksheet_Calculate()
ActiveSheet....

**0**

votes

**1**answer

21 views

### Pivot Table does not show all dates (last ones)

I got a problem with my pivot table. In my sales table it doesnt show me the last dates of my sales time period. I guess its because there have been no sales in the last two days (values = 0). For ...

**0**

votes

**0**answers

19 views

### Toggleable series in a pivot chart

I have a pivot table in which I show three different series, Ca, Na, and Li:
Now, ideally I want to have a toggle which lets a user decide which of the three series to show, without having to bring ...

**0**

votes

**1**answer

42 views

### How to create a histogram with 2 legends based on dates

I have a table that is created automatically from Power Query.
It looks like this:
| Event | Start Date | End Date |
+--------------------+------------+------------+
| Champion's ...

**0**

votes

**0**answers

26 views

### Excel - Pivot Chart formating reset when filtered

I am trying to create a pivot chart which shows 2 types of data, sales and headcount by year. Ideally, this would be done with a primary/secondary axis. When I set this up and change any of the ...

**0**

votes

**0**answers

199 views

### Compare current month to same month last year in Excel pivot table

I am creating a Sales Report for our Executive team, and the request with the most priority appears to be comparing sales in a given month to the sales in the same month of the previous year.
I have ...

**0**

votes

**0**answers

39 views

### Excel chart is not displaying chart lines correctly?

Please see the below image. I need to figure out why smaller dollar increments are showing up higher on the graph. For instance, why is $58.62 appearing higher than $59.96 in the top line?
This is ...

**0**

votes

**0**answers

31 views

### Converting Pivot Charts to svg format

Hi so I was wondering if it's possible to somehow convert a pivot chart to an svg format. By that I mean somehow keeping the functionalities of the pivot chart in place so that the chart would change ...

**0**

votes

**0**answers

32 views

### Is it possible to use the fields as a slicer? Excel Pivot Table

I am wondering if it is possible to use selected fields to be a slicer?
For example, if the pivot table has a field of Color, store, state, 2016, 2017, and Year 2018. Can I create a slicer for the ...

**2**

votes

**1**answer

292 views

### Excel: Pivot chart of values using value-stdDev as error bars?

I have a table of measurements, with each data point being measured multiple times.
I would like to create a PivotChart which displays the
average value and uses the value's standard deviation as ...

**0**

votes

**1**answer

3k views

### How to make multiple pivot charts from one pivot table?

I have a pivot table with fields comprising of sums and average. I want to create two separate charts (one for the sum, and other for the averages).
Every time I try selecting a pivot chart, it shows ...

**0**

votes

**1**answer

40 views

### Create Excel Chart Data Series based on Cell Contents

all. I do not see an answer to my problem in this site, so hopefully I can find help from you all.
I have a table of data, reflecting pseudo-Project Management data. The table is 7,000+ rows long but ...

**1**

vote

**0**answers

854 views

### How to lock the format of a pivot chart

I have a pivot chart from a group of data, and I need to show it in a specific type of different charts (combo charts) and giving every bar and lines a specific color. The problem is that every time a ...

**1**

vote

**0**answers

699 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

403 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"?

**2**

votes

**9**answers

32k 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

294 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 ...

**1**

vote

**0**answers

376 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 ...

**2**

votes

**2**answers

8k 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

18k 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

78 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 ...

**1**

vote

**3**answers

16k 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

163 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

5k 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

2k 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

5k 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

326 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

164 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

220 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

444 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 ...