A "pivot chart" is a method of summarizing data in diagram form. Typically, these are used for cumulating multidimensional data under common categories and visualising the data in a simplified form. Aesthetically, a pivot chart is less exact and more revealing than its tabular counterpart, the "pivot table".
Questions tagged [pivot-chart]
119 questions
0
votes
1 answer
Excel pivot chart grand total
I am trying to display the Grand Total in a Pivot Chart using Excel 2013 but this doesn't seem to be working. I have created a Sheet that extracts data from SQL and from this data sheet, I create my Pivot Table and Picot Chart.
I have created a…
PKirby
- 859
- 3
- 16
- 36
0
votes
1 answer
How to filter data in pivot charts based on row contents
I don't even really know how to search for this, so I apologize if this has been asked already. I couldn't find anything.
I have data for a bunch of tests which is structured like so:
+---------+---------+-----------+-----------+
| TESTNUM |…
HudsonMC
- 170
- 2
- 9
0
votes
1 answer
Django-Chartit2 'dict_keys' object does not support indexing error
I am exploring Django Chartit2 package for charting purpose by following the demo examples provided here. I have created my own Model for Pivot Charts which contains fields: city, person and sales.
In my views I am creating PivotChart by making use…
Punit
- 149
- 3
- 9
0
votes
1 answer
Distinct cumulative count - PowerPivot, calculated fields and DAX
I have struggled with this problem:
Pivot chart cumulative (running in) distinct count
I am copying it here for convenience...
The idea was to create a cumulative distinct count using this data set:
Month ¦ Drink brand ¦ Drink…
zaptask
- 687
- 1
- 8
- 18
0
votes
1 answer
How automatically to identify series when creating graph
Right now I have three columns of data that I would need on a graph. It's about the score of different countries on non-related evaluations. So there's a column for the year of the evaluation, the name of the country and the score it got.
Since…
Jn Coe
- 75
- 6
0
votes
0 answers
Excel spreadsheet missing a reference sheet name
I inherited an Excel spreadsheet.
It houses about 80 graphs. I am missing the sheet name draft that is referenced. There is not a sheet named draft with hide or unhide yet all these graphs reference that sheet name. Here is a sample of the graph…
0
votes
0 answers
Duplicate numbers on axis in Pivotchart
I have a pivotchart in excel that shows integer values along the y axis. However, when these values becomes sub 5, I get duplicates for some numbers. It seems like this happens to fill up the whole horizontal area. Anyone know how I can avoid this?
bjornasm
- 2,211
- 7
- 37
- 62
0
votes
0 answers
Excel Pivot chart clears Data Labels when refreshed
I have two identical Pivot Charts (same chart template) on two different data sources. When I hit refresh all both have new data, first one with retained formatting and the second one is missing data labels (usually not all of them but randomly 1 or…
Adrian Chrostowski
- 424
- 9
- 30
0
votes
1 answer
Pivot chart (Excel) fails to render the data the way I want
I'm creating a piece of Java code to fill data into an excel file. The file is pre-created, inlcuding a pivot chart and some vba code.
Though the java code works, I have some problems getting the pivot chart itself to work. I've included a…
samjaf
- 1,033
- 1
- 9
- 19
0
votes
1 answer
Slow down timeline in Pivot View
I have been using timeline in Pivot View in Excel 2013. In the play axis I have place year. The timeline rolls very fast such that I even cannot get an idea about how the data is changing over the years.
user1606651
- 17
- 5
0
votes
1 answer
Count dates in one chart with PowerPivot.
I am trying to do some analysis with MS Excel PowerPivot. I have a table, let's call it tb_policies. This table has the columns start_date and end_date and
I need a single chart that shows the count of started AND ended policies for a period of…
user3601549
- 9
- 1
- 2
0
votes
1 answer
Combining some values columns in a pivot table
If I have a pivot chart with a single axis, and three values columns (from two sheets), is it possible for me to combine two of these three values columns. In other words, in the below chart, can I combine the two New columns.
I've tried using…
Andrew Martin
- 5,619
- 10
- 54
- 92
-1
votes
1 answer
Filter a PivotChart with Dates
I'm trying to introduce a Chart with a PivotChart on Excel, but the data is in an Access Database.
I show my Chart perfectly, something like that:
Graph
Fields
But I want to display this same Chart with a Filter. A filter with a date field. And this…
lak
- 454
- 6
- 21
-2
votes
1 answer
How to update pivot table whose source data gets updated by a macros?
I have a dashboard by pivot charts. The source data gets updated via a macros. However, when i refresh data for the pivot tables, the source data table gets reduced to the headers of the source file? Is there a way I can refresh these pivot tables…
