Stack Overflow
Stack Overflow

Questions tagged [pivot-chart]

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".

119 questions
5
votes
1 answer

create a pivotchart with python win32com causes pywintypes.com_error

is there anyone can give a example code for creating a pivotchart in excel? I have got an example to create a pivottable with pivottable, it works , while when I try to create a pivotchart in the same ways, it will always failed! import…
xuanyao
  • 51
  • 1
  • 3
4
votes
1 answer

Pivot Chart series color based on row fields

New to pivot charts and their associated vba. But I'm attempting to change the colours of my bar graph depending on which province they belong to. I've been unable to use conditional formatting in a chart so I attempted a macro. Since I can't upload…
Rob
  • 65
  • 9
3
votes
1 answer

How to apply a filter to my pivot chart in VBA

I am trying to write a macro to create a pivot chart. I need the pivot chart to be a bar chart that has the columns filtered to only show 3 of the columns. Here is the code I have so far. 'Define Data Range LastRow = Dsheet.Cells(Rows.Count,…
Kevown Bechard
  • 55
  • 6
3
votes
1 answer

Excel VBA to filter Pivot Table and Pivot Chart for previous day - Pivot Filter Field

Here is my problem, every bit of code, every alteration, every type, doesn't work. I'm using Office 360 at my work site (up to date), so it's excel 2016 and VBA 7.1. What I'm looking to do is automate our end of shift reports. Here's the process: We…
DevilzEye
  • 31
  • 1
  • 4
2
votes
1 answer

Month & Week grouping in excel pivot tables with some empty data

I am working to group data in excel and I am trying to sort the input dates by month and week. I've found a number of ways to group by weeks (including grouping the date by 7 days and adding a helper column in the pivot table that numbers the…
Matthew
  • 31
  • 4
2
votes
0 answers

Formatting PivotChart Series

I have a pivot chart and I'm trying to format certain dataseries in my chart with a pattern. I recorded a macro to see how Excel would do that. This gave me: With Selection.Format.Fill .Visible = msoTrue .Patterned…
SilentRevolution
  • 1,495
  • 1
  • 16
  • 31
2
votes
2 answers

Creating Pivot table and chart In Excel COM for Autohotkey

I am trying to create a pivot table, and then a pivot chart from ahk for embedding into an email. I am a total noob, so please forgive my code quality. I am having trouble getting my pivot table set up right, and cannot get a chart to appear for the…
SmokeyTBear
  • 21
  • 4
2
votes
1 answer

SetSourceData for Chart returns HRESULT E_FAIL for PivotTable (Excel C#)

I want to create several PivotTables in a Sheet and from each PivotTable a Chart. The First PivotTable and the first Charts are created normaly. After I create the second PivotTable, I want to add a second Chart with the Source from the secound…
Daniel
  • 31
  • 8
2
votes
1 answer

How to debug a Pivot Chart Macro?

I am not able to run this, I want to count total rows in sheet and pass that to pivot chart to create. Pivot chart create select fileds Double click grand total to create new spread sheet Sub Macro2() Dim ws As Worksheet Dim lastRow As Long Set…
Siva
  • 115
  • 1
  • 3
  • 12
1
vote
1 answer

Is it possible to create Pivot Chart with source data as Pivot Table using Apache POI?

I am able to create Pivot Table and Pivot Chart using apache POI individually. But I am trying to create column chart form pivot table rather than directly from sheet data. I've tried look for guidance here but could not find any. If it is possible,…
Jonathan
  • 15
  • 5
1
vote
2 answers

Delphi - How to create Excel PivotChart

I am trying to automate a series of PivotCharts within Excel. I am using Delphi Rio and Excel 2019. I have an XLSX file, with one sheet, called 'Sheet1'. I have enabled record macro within Excel, and recorded the VBA code. I have ported it to…
user1009073
  • 3,160
  • 7
  • 40
  • 82
1
vote
0 answers

Excel Pivot Chart add Horizontal and Vertical Lines

So I have tried a couple of things and ran into a couple of problems. First of all my desired situation: I have a Pivot Chart based on data which contains Dates, Values and Locations. (A2A, A4A etc. are locations). I want to have a legend based on…
bert
  • 11
  • 2
1
vote
0 answers

Plot Selected Columns in PivotChart from Pivot-Table

My pivot table contains the Sum and % of 'N' and 'Y' queries generated using the PivotTable '% of RowTotal' and 'Sum Values' functions. I want to generate a Pivot Chart that Filters for FirstOpenedText and only includes two columns "Sum of # of…
beepboopbeep
  • 79
  • 6
1
vote
0 answers

Is there a way to Pivot Chart Min, Max, & Avg values after creating a Pivot to Sum?

I am using excel to merge a series of daily csv datasets with pivot. The data set has multiple runtime values for specific names on specific dates. I have built a pivot table to sum those values correctly. I now have a table that displays the sum…
nuprap
  • 385
  • 5
  • 22
1
vote
0 answers

How can I compare sets of categorical data to a sum of those categories in Excel? Needs to filter and chart

I have a survey data set that I need to periodically update and produce reports out of in Excel 2016. I want to filter the data by location and then compare locations by year>quarter to a total from all reporting locations ("provincial") using some…
LeroyBrown
  • 55
  • 6
1
2 3 4 5 6 7 8