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
2 answers

VBA to control Access 2010 Line Chart Marker color

I have created a pivot line chart in Access 2010. I am trying to use VBA to format the lines and markers so that my charts all look the same regardless of the series name. I can get everything to work except changing the marker color. Here is…
Michael Byars
  • 117
  • 2
  • 13
0
votes
1 answer

One PivotChart, Two Axes, Two Tables

Table contains series of transactions. Table columns include: 1. Date of Transaction 2. Amount of Income 3. Claim Name 5. Date Claim Filed 6. Date Claim Closed Multiple transactions containing income can be associated with a single claim. The…
Rycliff
  • 127
  • 1
  • 9
0
votes
1 answer

Excel Pivot Table Not Working when Using Formula

When creating values in a cell by using a formula: =IF(A2 = "RD", "RD", ""). Which says show value RD if RD and blank if not. I have three columns with different values, all set up the same way. When I try to pivot chart it, the data comes in but…
JackSki
  • 33
  • 2
  • 11
0
votes
1 answer

Excel PivotChart Treadline Horizontal Label

I've created a Pivot Chart from my Pivot Table, and added a Treadline to forecast the next four quarters. However, the horizontal axis for the new forecasts is blank. How can I add a label to the horizontal axis for the forecasted values (i.e. Q1,…
heyitsme
  • 33
  • 7
0
votes
0 answers

Combining identically structured tables into a single PivotTable

Good Evening, I have a number of workbooks each containing a table of identical structure. The columns are as follows: [ID] [Contract] [Team] [Type] [Jan Hrs] [Feb Hrs] [Mar Hrs] etc etc. Each of the tables holds an undefined number of rows.…
Jamie
  • 323
  • 2
  • 12
0
votes
1 answer

Grouping by in Excel Pivot Chart

Am asked to prepare a chart and I have an issue and seeking help here, Here is my Scenario: I have an EmployeeID, each day when the employee logs in there will be a transaction id auto generated, for this transaction id there will be 4 jobs…
user3387482
  • 93
  • 2
  • 10
0
votes
1 answer

How to combine Pivot Tables and also create custom formula in its fields - Excel 2016

I am preparing a Material Tracking System for my Paper Corrugated Fibreboard Production Unit using MS Excel 2016 for Windows. Basically, I will be entering the material details that are added to the Stock and as and when those materials are used I…
Chandan D Nadig
  • 157
  • 1
  • 4
  • 21
0
votes
2 answers

How to make all items except "(blank)" visible in an excel pivot chart?

When recording the deselection of the "(Blank)" items I get an explicit mention of all items. ActiveChart.PivotLayout.PivotTable _ .PivotFields("[Table1].[Field1].[Field1]").VisibleItemsList = _ …
TCN
  • 1,571
  • 1
  • 26
  • 46
0
votes
1 answer

How to separate 'Plot Area' from the 'Data Table' in an Excel Pivot Chart (standard line chart)

Whenever I add a 'Data Table' element to my Pivot Chart (Standard line chart type), it is combined with the X-axis or is overlapping the X-axis. This is preventing me from changing the alignment or any other formatting of the X-axis as it is…
Sighonide
  • 600
  • 4
  • 15
0
votes
1 answer

Pivot/Table filter activated through link from other table's cell value

I have a list of items to work through and some items require deeper analysis. Essentially I have two tables. The first shows production results and through filtering column U, I get a list of outliers as in the following image. Table of…
Sambo
  • 113
  • 1
  • 3
  • 12
0
votes
1 answer

How to fix the following error plotting some data?

Hello I want to plot some data, I am using excel i want to use a Pivot Chart just to plot two columns, one is called Products and the other Total, it seems really easy but when i press insert PivotChart and select the corresponding columns excel…
neo33
  • 1,809
  • 5
  • 18
  • 41
0
votes
0 answers

Hiding Pivot Chart Filters in Excel

I have a data table that will split into 20 types of Pivot charts. I was hoping to use a filter, so that I could just use the same set of data. I've done it, but each pivot chart has the same repeated filter items on the top. Is it possible to hide…
plateriot
  • 361
  • 5
  • 23
0
votes
1 answer

How to use another column as X axis label when you plot pivot table in excel?

I want to display Q2 2012, Q3 2013 instead of the auto generated labels of "sum of Apr to Jun 2012". But it's impossible to Edit the horizontal Axis labels here because this graph is generated by a pivot table. Thanks a lot!
Yang
  • 177
  • 4
  • 20
0
votes
1 answer

Sorting characters instead of numeric values in Pivot Chart

I want to generate pivot chart from pivot table. The problem here is my pivot table does not contain any numeric values. There are only some characters to differentiate them. So my pivot chart will be sort based on the characters like "A" and "B".I…
Belle
  • 71
  • 1
  • 2
  • 13
0
votes
1 answer

how to move a pivot chart with vba

i am trying to make a function that creates a chart next to the pivot table but cant make the chart move =( display the right data and works fine, its just been created to far away from the actual pivot table. Function chart_from_pivot(a_pivot As…
pelos
  • 1,744
  • 4
  • 24
  • 34
1 2 3 4 5 6
7
8