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
1
vote
1 answer

Excel Pivot-Chart : show last 25 lines

I have a set of data and i have a macro running adding a line each 5 seconds This is linked to a pivot-table and a pivot-chart in a Dashboard Looks like this (picture is my 2nd version with incremental instead of decremented) I have a field in a…
Uzwel
  • 11
  • 2
1
vote
2 answers

Pivot chart formats

very VBA-knowledgeable people, I have a pivot chart going on, and I wrote a sub to format the series representation. This chart contains four series and is connected to a slicer. The problem is that the formats aren't working for some of the…
SSGrace
  • 37
  • 6
1
vote
1 answer

How to hide blank rows from pivot-table so that the pivot-chart does not contain that row?

scenario: I have a pivot-table with years in rows and sales in values. Additionally I have sales as Difference to previous year (built-in pivot function "show as ...") in values. It works fine, but the first row in the pivot-table is blank for…
John
  • 35
  • 1
  • 7
1
vote
1 answer

Python win32com PivotCache.CreatePivotChart() error: 'Exception occurred'

There is one other question from Sep 2017 that addresses this same problem but does not have an answer: create a pivotchart with python win32com I have tried several approaches to get this working so I want to explain these and hopefully get some…
Threadid
  • 730
  • 1
  • 7
  • 27
1
vote
1 answer

Pivot chart changes source to different Pivot Table - Microsft Excel Bug

I finally made myself a fix for the bug in Excel where sometimes, seemingly at random, the source data for a Pivot Chart changes from, say "Pivot Table 32" to "Pivot Table 3". I had been hand editing all of these to end in text (which seems to stop…
Jon
  • 11
  • 1
1
vote
0 answers

Creating PivotChart with Apache POI Excel

I am trying to create pivotchart from a pivot table. How can it be done by using Apache POI? I searched Google but could not find any useful informaion. All information is about creating Pivot tables.
Bahri Gökcan
  • 980
  • 3
  • 12
  • 20
1
vote
2 answers

Excel Pivot table count between

I have a problem creating a pivot table/chart with between date function. I would like to know the total count of projects that are active between two dates. A Chart with on the x-axis week 1 - week 52 is what i'm trying to create. Example…
Mark
  • 41
  • 6
1
vote
1 answer

Use of variable in adding data to Values field of Pivot Chart using VBA

I have a data set which looks something like this Dataset However my number of days is a variable and will keep on changing. I want to use VBA to create a Pivot Chart, the code as below: Sheets("Initialize").Select NoRes = Cells(6,…
Suraj Shenoy Nagar
  • 11
  • 1
1
vote
1 answer

unlink pivot chart axis fields from pivot table rows fields

Is it possible to unlink a pivot chart axis selection from the pivot table rows? Whenever I remove one of the pivot chart axis fields to display the chart correctly, excel also removes the field from the pivot table rows selection which is not what…
Zeus
  • 1,496
  • 2
  • 24
  • 53
1
vote
0 answers

Excel crashes when cross filtering

I have a read only 2013 workbook I use as a template tool with a data model going to 4 linked pivot charts with slicer enabled cross filtering. When I select filter options on one slicer that filter out all options with data on another slicer my…
Zach H
  • 11
  • 3
1
vote
1 answer

Pivot chart cumulative (running in) distinct count

I need to create pivot chart (it is supposed to be pivot for the sake of very convenient filtering and efficiency but anything equivalent could do) showing cumulative distinct count. For example I have a data set: Month ¦ Drink brand ¦ Drink…
zaptask
  • 687
  • 1
  • 8
  • 18
1
vote
0 answers

Would like to limit the number of elements in a Pivot Chart filter

I am creating a pivot table with a corresponding pivot chart in VBA. I have filtered the data in the table to show only the top 5 values and the chart also only displays the top five values. However, if you click the field filter button on the…
Jay
  • 125
  • 1
  • 13
1
vote
1 answer

Would like to hide a filter button on a Pivot Chart

I have a pivot chart of a pivot table with two row fields and one column field. I would like to hide one of the row field buttons on the chart but leave the other visible to use as a filter. I see, when I right click on the button, the option to…
Jay
  • 125
  • 1
  • 13
1
vote
2 answers

How to create the equivalent to Excel pivot charts in R/ggplot2

I do a lot of pivot charts and I'm frustrated by Excel. Three weeks ago (as of 2/20/2015) I started learning R hoping to get more productive. With the bare basics covered, I installed ggplot2 in my R-Studio. I searched for ggplot2 tutorials but…
carlite71
  • 393
  • 1
  • 4
  • 16
0
votes
0 answers

How to export Syncfusion blazor pivot table and pivotchart in a single pdf page using Visual Studio 2022

I have a pivot table and pivotChart in a single razor page. I wanted to download both into a single file. I am using ExportToPdfAsync and ExportToChartAsync function to export the table and chart respectively. But now it is downloaded as 2 separate…
SHUHAIRA K.A
  • 11
  • 1
1
2
3 4 5 6 7 8