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
Set font on pivot charts to Arial
I am trying to update the font of the data labels on various pivot charts on the sheet of my workbook titled Dashboard.
I need to the chart data labels set to font Arial size 12 and the legend font set to Arial size 10.5.
I receive
Run-time error…
Nicole J
- 3
- 2
0
votes
1 answer
Applying "PivotField.Autosort" when generating a pivot chart
I am creating a macro to generate some clustered column pivot charts. I have used examples from the internet/stack overflow to generate the pivot table, generate the pivot chart and display the columns in decreasing order.
I have consulted the…
0
votes
1 answer
How to add target line to a pivot-chart?
I have a resource allocation report that automatically generates each week based on a bunch of monthly data. The data is summarized in a PivotChart with slicers for different column values (Name, Role, Project, etc). The chart shows the units…
clarabirch
- 1
- 1
- 2
0
votes
1 answer
How to change the data source of an Excel Pivot Chart?
I'm trying to reuse an Excel Pivot Chart to make similar charts from others Pivot Tables.
Suppose I make a Pivot Chart A from a Pivot Table A and customize its colours and formats. After that, suppose I need to make a second Pivot Chart B from a…
claudius
- 747
- 1
- 10
- 24
0
votes
1 answer
Add data and format Pivot Chart using VBA Excel
I am struggling to format a Pivotchart & add data to the chart using VBA. I have setup the code to create the pivot chart which is working fine and I can manually format & add data but whenever I try and mimic the macro recorder or anything I have…
Alan Treanor
- 157
- 4
- 19
0
votes
1 answer
Combining columns from 2 pivot tables in order to make a chart
I am trying to combine 2 columns from a pivot table with 2 other columns from another pivot table so i can make a pivot chart. I have no clue how it is done. I can make a pivot chart for a single pivot table, but what should i do in this case?
specbk
- 99
- 2
- 13
0
votes
1 answer
Is there a way to automatically or programmatically insert dynamic errorbars in a pivot-chart in Excel?
I have a pivot-chart that uses averages to plot each of my grouped points. I'd like to add errorbars, but Excel doesn't seem to support automatic errorbar generation (or does it?).
Should I just generate a standard graph / pivot-chart all in VBA to…
0
votes
0 answers
Why does my macro has to run twice to show pivot charts?
I have pivot charts in my workbook. Somehow, when I run my macro, the pivot tables are not showing. When I run the macro again, the pivot charts are showing. How come?
Also sometimes, but not always, the next line gives an error (in the part…
Aletta
- 1
0
votes
0 answers
Group countries to right continent and set filter for all continents in PivotChart
I have an excel data where orders from all over the world are listed. Now, I want to group the countries by their continents, and all continents to one "Continents"-Field to use it as a filter in my PivotChart. I have tried it already with the group…
Josh
- 51
- 9
0
votes
1 answer
Excel Pivot Chart 'fixed' horizontal axis
I have got a horizontal axis that holds numbers (roughly 7,5 through 18 at 0,5 intervals) based on the set filters.
I would like it to always show the 7,5 though 18 on the horizontal axis, even if the filtered only is applicable 10 to 12,5 for…
Bart de Brouwer
- 41
- 1
- 5
0
votes
1 answer
Create a Pivot Chart which compares an individual's score with that of his teams Average score
I need to compare how Fred is performing compared to the rest of his team Team 1 in the form of Pivot Line Graph. Below is the data.
A B C D
James Team 1 20 11/05/18
Fred Team 1 50 12/11/18
Elliott Team 2 …
WillacyMe
- 562
- 1
- 6
- 25
0
votes
1 answer
Where does the last value and blank date come from?
I have encountered a strange thing in my power pivot table and chart. I have the EUR/SEK in a table and chart and as you can see here
the last value is above 70 and the date is blank-blank-blank. I have obviously checked my table and there is no…
Carl-Philip
- 3
- 2
0
votes
0 answers
Excel - Pivot Chart - Count if a Start Time and End Time fall into timeslot
I'll do my best to explain.
I have data which has the Start Time and Period of Time an activity is carried out for.
e.g.
Name Start Time Activity Length (mins)
James 08:00 45
Phil 10:10 30
Angela 10:20 50
I…
WillacyMe
- 562
- 1
- 6
- 25
0
votes
1 answer
Excel - Change PivotCharts based on columns using slicers
I have a huge amount of data (200k+ rows and 10+ columns), compiled in this format:
Month Date Time Value1 Value2 Value3
Jan-18 1/1/2018 12:00:00 AM 10 20 30
Jan-18 1/1/2018 12:01:00 AM 13 …
Kevin Lee
- 27
- 1
- 8
0
votes
1 answer
Limitation line Pivot area charts
I'm leasing a car, which I use my self, but also rent out for other people to use. I have 2000km I can drive each month, so I'm trying to do an area pivot graph which will track how much I use it vs how much it's rented out.
I have a table column…
Martin
- 353
- 1
- 6
- 23