pivot chart

Hello, I'm trying to analyse some timesheet data that is being exported from MS Project Server. It has fields like - Time Period Resource Name (the 3 different charts) Project Name Project Sub Task Planned Work Actual Work I'm trying to create 3 pivot pie charts from which I can then select...

Hi all, I'm trying to lock down a spreadsheet so that users can change a Pivotchart using slicers, but not in any other way as I need data rounding as a calculated field. I can do this, but only by locking the Pivotchart, which means the user can't select it. This is a problem because I want...

Hi every one, I want to create two different pivot chart inter linked with a slicer. I have the following pivot tables and a slicer created from my source Data. <colgroup><col><col><col><col><col></colgroup><tbody> Product Name Amount Sales Person Amount CPU 35,886,152 Ami...

Hi All I have a pivot bar chart for production hours in a month. I want to add the cost of these hours into the chart as a data label to be placed inside the bar chart. Is this possible? EG - 409 production hours on the axis, this is correct and i dont want to change that, can i add a label...

First timer posting here! I need to calculate average of material purchase prices, weighted by their mass, while ignoring zero values, in each factory separately. There are several different countries, factories and materials (and material & quality categories), but all the materials are...

Hello! I am attempting to create a Pivot Table from a complex Excel sheet. Below is an example of 1 item I am tracking.... this is 1 of 70, and they usually have 20 or so "Social Insertions". The goal of the Pivot Table/Chart is to have an easy to digest overview of the month and of the...

Hi, I'm trying to create a dashboard with a number of Pivot Charts. Ideally, I want to include some code in the work sheet that updates the bar colours of the chart depending on the value of the Pivot Chart (red when it's negative, blue when it's positive). The dashboard is a visual...

Sir, I have created a Line chart with filters with the help of Pivot Table(Pivot Chart tool) in MS Office 2013 and it's working perfectly on Windows version of MS Office 2013. I have installed Windows 7. Now when I send it to my client, the filters disappeared. My client is using MS- Office 2016...

Hello Excel people! I've been working on a report, showing the total hours provided by each supplier, broken down by the Zone they are based. I've attached an image to show you, this is a Pivot Chart, controlled by slicers including a Linear Trend line Forecast. currently showing all...

Greetings! I'm working on identifying our high use/order items. I created a pivot chart with: items, date, quantity. I want to be able to have the text for the items and the date to be vertical instead of horizontal. Currently only the "item" or the "date" text is vertical. It changes by the...

Hi all Is it possible to create a Pivot Chart like this? The line is the total of the other series. I can create this by inserting a normal chart then choosing the total series as Stacked Line with Markers. Using a Pivot Chart you don't seem to be able to add the Grand Totals to the Pivot...

Hi, Is there a way you can do a drill through via a pivot chart to a metric as you would a regular pivot table?

Hi, I have a pivot chart linked to a pivot table. In the chart, I superimpose two types of charts, a bar chart (on the primary axis) and a line chart (on the secondary axis). Anytime any filter of the columns of the pivot table is changed, the chart type changes to all bar chart and I lose the...

I'm tracking the daily productivity for over 300 employees and 250 working days. Currently, the date/working day is the Legend Entry (Series) and the employee name is the Horizontal (Category) Axis Label. I need a way to switch them around so that the date/working day will be the Horizontal...

Hi, I've created a pivotchart/table containing values that have been recorded by 3 different PLCs. The CSV files contain the date and time for each value. My problem is that they all collect data at different time intervals. (One is every 5 mins, another is every 10 mins, and the last is...

Hi, I'm trying to create a pivot chart that has vertical columns and also a horizontal line signifying the target. I create this target line by using a stacked line against clustered columns. However, I seem to be having trouble retaining these horizontal lines after applying a filter. With no...

I'm hoping this is a simple problem to fix, thanks in advance for looking. I have a report that details lost time incidents by date. The report goes back 3 years. I have used grouping on the date column to seperate out years and months. the pivot table shows this perfectly. I then need to...

I am getting error at line , Method 'SetSource data' of Object' _Chart'failed oChart2.SetSourceData Source:=PT2.TableRange1 I have used this code in previous codes and it was working perfectly fine. Dim oChart2 As chart Set oChart2 = PT2.Parent.Shapes.AddChart(XlChartType:=xlBar).chart...

Hi, I am using Excel 2010 on Windows 7. I have some pivot charts that have custom labels. When the workbook is first opened, I run the Sub called AddDataLabelAsValues. This is called a few times and runs through a few ChartSheets and assigns custom labeling to the columns. For each pivot...

Hello, I am developing a Pareto Chart for my client in Excel 2010. They currently have a chart that shows the percentage of each category on the primary Y-axis. Then, the secondary Y-axis is used for the cumulative percentage, up to 100%. So far, this is a normal and easy to create...