pivotchart

So I currently have a bunch of hidden sheets with pivot tables on them, and a bunch of unhidden sheets with the corresponding pivot charts. I am querying SQL for a bunch of data, and then the pivot tables feed off this new data to create the charts. My current problem is that every time I run my...

Hi All, I have a large spreadsheet to track all my data. In one column I have a drop down menu that contains five options (Accepted, declined, on hold, TBC & Cancelled). When I create a pivot table I can only get one of these criteria to appear at a time and have to filter through using a...

Obviously the title should have said PivotChart to PowerPoint (sorry!) I'm looking for a way to paste a PivotChart into Powerpoint without retaining the link to the Excel file. Everything I have found so far is about how to keep the link active. I'm looking to break the link so I can use the...

Hello experts, I work in an organization where those who require data needs, want it spoon fed to them. I have a complex report which I'm utilizing pivot tables to help filter. My issue is the things they want to view could be easily done if they would use the slicers BUT they won't. So what...

I'm trying to create a PivotChart like the one below. As we're not yet not into December, I would like to hide the column for month 12 - but still display the target for the month as shown below. The 'actual' values (the columns) are shown as 'Running Total In' while there's no calculation...

Hi everyone, I created a speedometer chart using a combination of a doughnut and pie chart (in one) based off a YouTube tutorial I found here: https://www.youtube.com/watch?v=f6c93-fQlCs The problem I'm having is that the needle only goes from 0 to 100, but I need it to go from -100 to +100...

I'm trying to create a PivotChart that looks like this: However, since my data is organized like below I cannot find a proper way to do that. And my chart ends up looking like this, where I have a line for each sales stage: Is there any way I can sum the the perceived sales value, so...

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

I have a PivotChart that shows the target date of certain action items as well as the % completion of those action items. I've also included a progress bar showing the current date, and all of this information gets updated with a refresh click. What I want to be able to do is cycle through the...

Hi All, I have searched the forums far and wide to try and find a solution but have come up empty. I am currently using PowerQuery to bring in some SQL data, perform some transforms and then load it into a data model using Power Pivot. I have created some custom columns to do some calculations...

I have data, a pivot table, and associated pivot chart sheet originally created in 2007 saved in a xlsm file. Error and empty values in the pivot table are set to show as "#N/A" so don't plot in the chart. There's also some code which makes various table field selections and creates hard-coded...

http://i.stack.imgur.com/5z5Hr.png I have a dataset which I have simplified a bit for this post. From the image above you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual (measured) output. For this case the measured output is...

hello. can anyone tell me how to add the grand total in pivot chart?! :rofl:

I have a PivotChart that graphs performance by month for each doctor. For example, DOCTOR A has a stacked bar for February, March, and for April. DOCTOR B has the same months and is right next to DOCTOR A and so on. The pivot table summarizes performance by month AND gives a cumulative rate...

Hello everyone, I have a question. I have a PivotChart based on these values: Those columns are names of the days. I want a PivotChart that shows me the Colmun total, but now it shows "Dinsdag" (Tuesday). It shows this: How can i fix this (I don't want to remove the day column's) By the...

Hi Guys, I have a sheet of data which reflects e-mails that have come into a mailbox. Columns: Date, Category of e-mail, Time take to respond, SLA misses, Comments. (The table begins on A1 with the last column being F1). There are curerntly 50 rows of data. I want a piece of VBA code to...

Hello, I'm looking for help in creating a chart that will autofill according to results produced by a pivot report. I've succeeded thus far, but am nowing facing the difficulty of data in my pivot table producing either four rows of data or five rows of data. Is there a way that I can make my...

I have 5 data tables that all contain a roster with the same last names, but with different types of data. I have added each data table to the Data Model. Each time I try to combine one person's data from Table A with Table B, Excel prompts me to create a relationship. I've tried creating a...

I have hourly output data for an entire year. I made data columns for month, week of the month, day of the month, day of the week, and hour of the day. Currently, I have a decent Picot Chart set up that as weekday and hour in the Axis Fields category, month and week in the Report Filter...

Hi guys, I'm looking for a solution for embeding a pivot table/chart in a powerpoint presentation. After a lot of searching I found a solution through access. It worked in importing the pivot table to the slide - but as soon as I tried to go to Slide show the functionality is gone with the...