Questions tagged [pivot-chart]
The pivot-chart tag has no usage guidance.
70
questions
0
votes
0
answers
32
views
Excel Pivot Chart Seconday Axis Disappearing
I have an Excel pivot chart, used to measure quoting metrics in our sales department (showing the top 5 clients based on most activity), consisting of a combo chart (stacked column & line).
Below ...
0
votes
1
answer
111
views
Joining a pivot table and a normal table to create a graph
I am having a hard time building dynamically a graph that results of joining together a pivot table summarizing some data, and a data field from another table, both sharing a common primary key/column....
0
votes
0
answers
22
views
Excel - populate pivottable axis dates for trendline
I have the following pivot table, showing products in the following level of details (LOD)
1- Year
2- name
3- type
The following picture shows them at LOD 1:
I want the chart to populate the missing ...
0
votes
0
answers
181
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
216
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
132
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
729
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
151
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 ...
2
votes
2
answers
729
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
4k
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
38
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
3k
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
99
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
313
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
3k
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 ...