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
0 answers
I have a special case with data representation(e.g., Funnel chart)
Hello Excel masters,
I need your help in representing my data. I have quite complex data, but I don't want to get confused, so I took a simple…
Garudaraja
- 63
- 7
0
votes
0 answers
Excel VBA Getting error when creating pivot chart but error only occurs after sub that creates pivot tables. No error if directly called
This is the code in an Excel user form. I have two subroutines. Number 1 CreatePivotTable & Nummber 2 CreatePivotCharts. If I run them consecutively when comandPivot is clicked, the pivot tables are created properly but I get an error in…
Steven Greenbaum
- 311
- 4
- 17
0
votes
1 answer
Office JS - Excel, Add pivot chart
How can I add a PivotChart with office.js?
I can see the pivotOptions property for chart (https://learn.microsoft.com/en-us/javascript/api/excel/excel.chart?view=excel-js-preview#excel-excel-chart-pivotoptions-member)
but I couldn't find a clear…
yossico
- 3,421
- 5
- 41
- 76
0
votes
0 answers
Pivot Charts in Excel
I created multiples Pivot tables from different external data sources. There are six pivot tables that reference the same information but from 6 different months. I am trying to create a Pivot chart with the information on those 6 pivot tables.
I…
Indira
- 1
0
votes
1 answer
Excel VBA to dynamically highlight bar color based on drop down list value
Edit: I want the vba code to iterate through the x values(categories) in the pivot chart and if the xvalue equals what is in cell C4 then I want it to make that bar color red. Otherwise, the bars should be blue.
This is what I have so far, but it…
0
votes
0 answers
Automating spreadsheet to pivot chart error 1004. I am wondering why it comes with this error after I recorded the macro
Sub Test()
'
' Test Macro
'
' Keyboard Shortcut: Ctrl+Shift+T
'
Range("A1:N226").Select
Sheets.Add
This is the problem area -----
* ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"reports_statistics…
timmx240
- 1
0
votes
0 answers
How can I manually change the date format of a Pivot Chart?
I have a Pivot Table that has been used to create a Pivot Chart. The x-axis shows dates, while the y-axis shows the magnitude of the data against each date. The date format being used is "mm/dd/yyyy" - however, when I try to change the format to…
MominaAthar
- 29
- 9
0
votes
0 answers
How to use python to draw pivot chart similar to excel pivot plot?
I want to create a pivot chart plot using python and below is the data format(csv file)
below is the pivot chart plot using excel:
The code I used to generate pivot chart:
expect to see the same result as excel plot
As you can see from the figure…
Chase Wang
- 1
- 1
0
votes
0 answers
Graphing an Allselected measure whilst filtering with slicer on related table
I am trying to create a dashboard in Excel. I have 3 tables loaded into power pivot, Attribute_T, Valuation_T and Brokerdetails_T.
Table data
Table…
Fankastic
- 3
- 2
0
votes
1 answer
Create a calculated pivot table column in excel based off other columns in the pivot table?
So I have a bunch of rows in a query table that shows orders from a certain timeframe and whether that order had a "defect" or not. I have started a pivot table on that table to summarize the # of orders and # of those orders that were defective by…
0
votes
1 answer
Can this Excel pivot chart be duplicated in ggplot?
Is it possible to duplicate this Excel pivot chart with ggplot2 or have something relatively similar? I really like that the chart displays the prices and the year-to-year percent changes on the legend below.
Here's the dput() output of my sample…
EastBeast
- 89
- 7
0
votes
0 answers
Empty Pivot Chart
I created Pivot charts for a given data. Next I added more rows to my data by -> Pivot Chart Analyze -> Change Data Source In Pivot table there are data (rows - months, columns - value of some measure), but the plot is empty (both x and y axis looks…
Placer
- 37
- 5
0
votes
1 answer
How to pivot chart 2 data types from a specific date in Excel?
I'm trying to do a dashboard which it looks fine, but I have one problem with a line chart.
I'll try to explain what I want to achieve.
I have a table like this:
| ID | Received Date | Completed Date | Status |
|----|---------------|…
Dark161000
- 31
- 5
0
votes
0 answers
Pivot table column name and Horizontal Bar in Pivot Chart
Ugh. As you can see, my pivot table has a problem - I probably don't understand pivot tables very well in that case.
I want the pivot table to state "Months" in the first column and not "Row Labels".
Also, I'd like to have a horizontal line appear…
michalinator
- 41
- 4
0
votes
1 answer
How to display date from a specific month in Excel Pivot Chart
I want my chart showing period from FEB-2020 to DEC-2021. However, if i filter away January, it will remove January for 2020 & 2021. This is because, "Years" & "Date" They are independent filters. How to only filter away JAN-2020 only?
MR ABALONE
- 27
- 6