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
0
votes
1 answer

excel pivot chart multiple date series

I need to produce a pivot chart that has multiple series based on the count of dates in a given month. I can generate this if I have only one date column in the pivot table, but if I have more than 1 date column, the pivot chart combines the data…
user9443690
  • 1
  • 1
  • 1
0
votes
2 answers

PowerBI: Getting Pivot table level of flexibility with calculated fields

The great (for me at least) thing about having reports built in Excel with Pivot Tables and Charts is that I can have a calculated field that reacts dynamically to whatever is displayed (sliced) at a given time. From my pretty short experience with…
IgorM
  • 186
  • 1
  • 10
0
votes
0 answers

Pivot Chart not reflecting data correctly

I am a bit new to Pivot charts but I am trying to build a dual axis chart that shows the total purchase order Count and the Average age of purchase orders. I have posted a screen grab of the chart. The PO count is changing over the dates as I would…
user3496218
  • 185
  • 3
  • 5
  • 19
0
votes
0 answers

Blank pie-chart with pivot table

I am trying to create a pie chart from some pivot table data but it is just appearing blank. Pivot table data: What my pie chart shows: It works ok in other slides so im unsure as to what the issue is. Any help would be great, thanks
Ryan Gadsdon
  • 2,272
  • 4
  • 31
  • 56
0
votes
1 answer

Change color of axis bars in an Excel pivotchart

I have this PivotChart in Excel 2016 As you can see there are two properties in the axis field: "Date" and "Category". There are two possible values for "Category": ASC and SBT. Right now the bars related to either values are of the same colors…
Ponzaro
  • 139
  • 2
  • 5
  • 16
0
votes
1 answer

How to convert matrix to 4-column table without using VBA (Data - PivotTable and PivotChart Report)

I need to convert Excel matrix "A" into table "B", but not using VBA. Preferably 'reverse pivot', 'unpivot', 'flatten', 'normalize'... Picture of what I have and need to receive There are similar topics, but couldn't find the exact one I am…
Monika Dolega
  • 1
  • 1
0
votes
0 answers

How to identify pivot chart on an excel worksheet using VBA

I'm creating an excel dashboard in which I've placed a pivot chart and I want to govern its visibility by the click of a checkbox. I'm not able to identify the pivot chart object on my worksheet and hence can't use the code I can do for any other…
hbabbar
  • 947
  • 4
  • 15
  • 33
0
votes
1 answer

VBA Pivot Chart Categories Not Counting or Displaying Correctly

I have a table that uses another table's values as a look up for fields in a data table. [Parameters] is the table that holds the look up values and [Sample Log] is the data table that looks up possible values from [Parameters]. [Sample Log].exp =…
Chemistpp
  • 2,006
  • 2
  • 28
  • 48
0
votes
1 answer

Set specific color for a Legend in a dynamic Pivot Chart

I have a pivot chart with data coming from a Power Query - SQL Source. Colors in Pivot Chart follow a pattern depending on the number of legends. It always starts with light blue (based on my theme choice) but legend values are not static since it…
Chester Lim
  • 459
  • 7
  • 19
0
votes
1 answer

Excel Dashboard Bloat: Multiple pivot charts based on single pivot table

Goal: I am trying to build a dashboard in excel using one pivot-table & multiple charts based on that pivot-table. The pivot-table have to have a access query data link. Problem: Currently I build a data link for every chart because I cant find a…
Rhdr
  • 387
  • 4
  • 22
0
votes
0 answers

Excel Weekly Schedule Pivot Table

I'm creating a dashboard for a company with multiple employees at multiple locations. They want a schedule with slicers that shows them different locations or specific employee schedules. I'm wondering if something like this is possible using pivot…
Zach Shaner
  • 43
  • 9
0
votes
1 answer

How to make my pivot fields dynamic in vba code

I have a pivot table that sorts data for various people for each month over a 12-month period. The table that the data is generated from has a dynamic date range (ie the user can specify the start date which will cascade through the table). The…
A.Doe
  • 25
  • 1
  • 12
0
votes
1 answer

How to treat pivot table column names as integer in pivot chart (Excel)

I am trying to plot data in a bar-chart. On the x-axis I want to display the answer category (1-9) and on the y-axis the amount of times it has been chosen. Not every category has been selected, which results in the following pivot table: …
Robin Kramer-ten Have
  • 818
  • 2
  • 13
  • 34
0
votes
1 answer

VBA MS Access 2010 pivot line chart add data label to first marker only

These little VBA language differences between Excel and Access are getting very anoying. I am at the last step (hopefully) of getting my line chart to look how I need it to, but I can't get a data label to show on the first marker only. Here is…
Michael Byars
  • 117
  • 2
  • 13
0
votes
1 answer

VBA Access Pivot Chart set the y-axis min/max scale

Came into another snag formating my Pivot Chart via VBA in Access 2010. I get the "Run-time error '438': Object doesn't support this property or method" error. Again, I have tried many different iterations of the code, but can't get the right one. …
Michael Byars
  • 117
  • 2
  • 13
1 2 3 4 5
6
7 8