Questions tagged [pivot-chart]

The tag has no usage guidance.

39 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
1 answer
3k 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 - ...
Rory's user avatar
  • 585
2 votes
0 answers
75 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 ...
User1974's user avatar
  • 137
2 votes
2 answers
526 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 ...
CORCSIR's user avatar
  • 21
2 votes
0 answers
3k 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 ...
Tahlor's user avatar
  • 155
2 votes
3 answers
14k 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 ...
Gaurav Lakhotia's user avatar
1 vote
0 answers
181 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 ...
Camilo Enriquez's user avatar
1 vote
0 answers
33 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. ...
ahh_real_numbers's user avatar
1 vote
0 answers
67 views

How to make a grouped stacked chart in Excel? (see picture)

How do I make a chart like the one below here?
Victor Nielsen's user avatar
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 ...
SpeedCrazy's user avatar
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"?
pilti's user avatar
  • 11
1 vote
0 answers
736 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 ...
Pop Claudiu's user avatar
1 vote
0 answers
109 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 ...
jtd's user avatar
  • 111
1 vote
0 answers
177 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 "...
T-House's user avatar
  • 11
1 vote
1 answer
1k 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 ...
Cindy's user avatar
  • 11
1 vote
0 answers
62 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") ...
Stella's user avatar
  • 11
1 vote
0 answers
47 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:...
Max Beggel's user avatar
1 vote
1 answer
3k 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 ...
Kenny M.'s user avatar
0 votes
0 answers
14 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 ...
Ali's user avatar
  • 41
0 votes
0 answers
119 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 ...
Christian A. Rasmussen's user avatar
0 votes
0 answers
426 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 ...
user1769136's user avatar
0 votes
0 answers
3k 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 ...
User1974's user avatar
  • 137
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 ...
Sybrand E. Smit's user avatar
0 votes
0 answers
264 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 ...
Monomeeth's user avatar
  • 1,289
0 votes
1 answer
66 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: ...
Max Muller's user avatar
0 votes
0 answers
51 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 ...
Thorbjørn Ravn Andersen's user avatar
0 votes
0 answers
68 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 ...
RazorX87's user avatar
0 votes
1 answer
56 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 ...
Austin's user avatar
  • 101
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 ...
sonic99's user avatar
  • 51
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 ...
Harry Browning's user avatar
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 ...
Lisa B.'s user avatar
0 votes
0 answers
36 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 ...
eirikdaude's user avatar
0 votes
1 answer
282 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 ...
watatixo's user avatar
0 votes
0 answers
543 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 ...
Kulstad's user avatar
0 votes
1 answer
415 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 ...
Michael Boonie's user avatar
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 ...
Sebastian's user avatar
0 votes
1 answer
613 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 ...
m.j.p's user avatar
  • 45
0 votes
0 answers
1k 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, ...
pdanese's user avatar
  • 161
0 votes
0 answers
67 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 ...
Arun's user avatar
  • 1
0 votes
0 answers
2k 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 ...
Jim22150's user avatar
  • 103