Questions tagged [pivot-chart]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
16 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 ...
user avatar
0 votes
0 answers
26 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 ...
user avatar
  • 1,195
0 votes
1 answer
29 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 ...
user avatar
0 votes
1 answer
114 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 ...
user avatar
1 vote
0 answers
43 views

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

How do I make a chart like the one below here?
user avatar
0 votes
1 answer
19 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: ...
user avatar
0 votes
0 answers
24 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 ...
user avatar
0 votes
0 answers
49 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 ...
user avatar
0 votes
1 answer
505 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 ...
user avatar
0 votes
1 answer
111 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 ...
user avatar
2 votes
1 answer
382 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?
user avatar
0 votes
1 answer
67 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 ...
user avatar
0 votes
1 answer
41 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 ...
user avatar
  • 1
0 votes
0 answers
41 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 ...
user avatar
  • 51
0 votes
0 answers
720 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 ...
user avatar
1 vote
1 answer
3k 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....
user avatar
0 votes
1 answer
2k 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 ...
user avatar
0 votes
0 answers
23 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 ...
user avatar
0 votes
1 answer
94 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 ...
user avatar
0 votes
0 answers
350 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 ...
user avatar
2 votes
1 answer
686 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 ...
user avatar
  • 374
0 votes
1 answer
9k 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 ...
user avatar
0 votes
1 answer
216 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 ...
user avatar
0 votes
0 answers
2k 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 ...
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 ...
user avatar
1 vote
1 answer
815 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"?
user avatar
  • 11
4 votes
9 answers
68k 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 ...
user avatar
  • 97
0 votes
1 answer
694 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 ...
user avatar
1 vote
0 answers
588 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 ...
user avatar
2 votes
3 answers
20k 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 ...
user avatar
  • 125
1 vote
2 answers
24k 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 ...
user avatar
  • 6,032
1 vote
0 answers
98 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 ...
user avatar
  • 111
1 vote
3 answers
37k 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 ...
user avatar
1 vote
0 answers
170 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 "...
user avatar
  • 11
0 votes
1 answer
9k 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 ...
user avatar
0 votes
1 answer
3k 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 (%...
user avatar
2 votes
1 answer
8k 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 ...
user avatar
  • 121
0 votes
1 answer
495 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 ...
user avatar
  • 45
1 vote
1 answer
333 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/...
user avatar
1 vote
1 answer
541 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 ...
user avatar
1 vote
1 answer
838 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 ...
user avatar
  • 11
1 vote
0 answers
59 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") ...
user avatar
  • 11
1 vote
1 answer
2k 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 ...
user avatar
  • 328
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, ...
user avatar
  • 131
0 votes
1 answer
14k 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 ...
user avatar
3 votes
1 answer
2k 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 - ...
user avatar
  • 555
2 votes
3 answers
10k 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 ...
user avatar
1 vote
0 answers
44 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:...
user avatar
0 votes
0 answers
64 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 ...
user avatar
  • 1
0 votes
1 answer
695 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 ...
user avatar