Questions tagged [pivot-chart]
The pivot-chart tag has no usage guidance.
67
questions
0
votes
0
answers
47
views
Hide the 100% column when using the "Show value as % Of another base item" in Excel Pivot Chart
I'm doing some fairly light reporting in Excel and have run into a problem I can't seem to figure out on my own.
I have data in a format similar to this:
ID
Location
QuestionText
Value
1
AAL
Sick ...
1
vote
0
answers
131
views
Excel how to group up data by percentages
I have a graph which many Series, but I only need the first 5 and I want to group up the rest as a Series of its own called "others".
Here you can see how all the smaller data below the top ...
2
votes
0
answers
55
views
Change PivotChart source from one PivotTable (external data source) to another PivotTable (table/range)
I have a PivotChart in Excel 2016 that is currently based on PivotTable-A.
PivotTables A and B are identical, other than the fact that they have different data sources:
A's data source is an ...
0
votes
0
answers
178
views
Pivot graph show only data based on cell colour
I want to set up a pivot graph who only shows values based on the fill colour of the cell.
The graph should should the amount of cells with (e.g.) green, yellow, and red cells.
Can someone advise on ...
1
vote
1
answer
67
views
Force bar chart to show missing years within 10-year range (system year + 9)
I have a table in Excel 2016:
YEAR_ AMOUNT
---------- ----------
2024 100
2025 200
2025 300
2026 400
2027 500
2028 ...
1
vote
2
answers
233
views
Excel: Create truly blank cells from formula so that they wont show up in a pivot table?
So I've had a look at similar answers but they're not working for me. Basically I have a lot of related charts of monthly data, and I'm wanting to plot them on a chart that only shows up the current ...
0
votes
0
answers
2k
views
Pivot bar chart legend order
I have a PivotChart that is a stacked bar chart in Excel 2016.
I want to control how the Ward numbers are displayed in the chart.
I want to keep the PivotTable Ward number columns in alphabetical ...
1
vote
0
answers
22
views
How to filter rows for a pivot chart to ensure one to one relationship in results
I am trying to put together a PivotChart as such:
Each recipe is made up of ingredients. Each ingredient maps to (potentially) many products. Croissant Dough for instance calls for 40g of butter. ...
0
votes
0
answers
2k
views
Run Excel Macro when Slicer is Clicked
I have a PivotTable connected to a Horizontal Bar Chart. When I filter the content to be displayed in the Chart (by using the Slicer), the Chart did not resize according to the entries displayed. This ...
1
vote
1
answer
56
views
Plot device ON/OFF data in excel
I have following data containing
a device
a timestamp of when the deviced logged the event
an event: ON or OFF
I would like to get a graph that shows per day the duration a device was active (...
1
vote
1
answer
192
views
Bar chart reduce number of labels by creating Others
pretty new in excel and I'm currently working on a pivot table and want to create a bar chart.
I have around 15 row labels and 2 columns- row labels and percentages that looks something like this:
...
0
votes
1
answer
2k
views
Excel Pivot Charts - Creating different charts (with different grouping) from the same data
I would like to create (at least) two pivot charts sourced from the same data that display the data in different groupings; one will be grouped by years, the other grouped by months. I am able to ...
0
votes
0
answers
234
views
Excel Pivot Table Chart - How NOT to plot any Top 5 items with a zero value OR only plot the first 5 regardless of value
I have created a Pivot Table in Excel and used the Value Filters > Top 10 filter to only show the Top 5 entries based on a particular value.
I have created a Pivot Table Chart based on the above ...
0
votes
1
answer
44
views
Pivot calculated field of variation
I want to create a pivot graph that shows the variation (%) in number of road accidents from year to year+1. I need it to be pivot because I want it to be refreshable if data change.
My data is a list ...
0
votes
1
answer
523
views
Pivot table column name and horizontal bar in Pivot Chart
My pivot table has a problem.
As you can see,
the first column has a heading of "Row Labels" (in cell A10).
I want it to say "Months".
Also, I'd like to have a horizontal line ...
1
vote
0
answers
64
views
How to make a grouped stacked chart in Excel? (see picture)
How do I make a chart like the one below here?
0
votes
1
answer
46
views
How does one ensure only relevant data points are included in a pivot chart in Excel?
I'm currently working with pivot charts in Excel for the first time and I'm having a bit of trouble with it. The following image provides an example of what is not going entirely according to plan:
...
0
votes
0
answers
38
views
Excel group "box with whiskers" chart by time
I am logging various data every five minutes from my broadband modem to learn how my devices behave over time. This results in a lot of data I would like to use Excel to analyze.
One piece of data ...
0
votes
0
answers
67
views
Excel 2013 Pivot Chart: wrong day-count on y-axis
I'm making this pivot-chart where the orange series shows the average count of days (gg) with hh:mm:ss part.
Now, as you can see on the picture the pop-up shows the correct value (00gg 23:53:37), but ...
0
votes
1
answer
1k
views
Adjust gridlines in excel PivotChart
I have the following data:
Now I create a Pivot Chart which looks like this:
I add vertical gridlines. However, my problem is that the gridlines are not exactly on the year centered, but the actual ...
0
votes
1
answer
256
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 ...
2
votes
1
answer
1k
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
206
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
1
answer
54
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
42
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
1k
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
4k
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
5k
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
35
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
273
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
496
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 ...
2
votes
1
answer
939
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
14k
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
396
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 ...
0
votes
1
answer
3k
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
1k
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
1k
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"?
4
votes
9
answers
85k
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
2k
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
705
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
3
answers
27k
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
26k
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
107
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
52k
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
175
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
11k
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
4k
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
11k
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
582
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
606
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/...