pivot charts

Names columns Dates column Ok so I have this table that has dates on one side and names on the other. I am trying to figure out how to turn it into a pivot table where I can filter by name so I can add it to the slicer for the rest of my dashboard. I have tried it as the original data and...

Hello, I have a question on pivot charts. Let's say there is a pivot table with 3 columns. 1st:Issue name, 2nd:opened date, 3rd: closed date. The column with closed dates contains blank cells. I want to make a chart with 2 lines. X axis with dates and Y axis with number of issues. Each line...

Hello, I created pivot charts through power query and every month I add new info to the database and the charts update. They are line charts comparing two values. The problem is: when the charts are updated with new values, sometimes the data labels overlap... is there some vba code to prevent...

Hey; When pressing on a pivot table it will take you to the raw data. Example: Pressing on number 5 for the sum of "misplaced products", it will give you the list of the misplaced products. But when a pivot chart is made out the pivot table if you are to press the pivot chart nothing occurs...

I am trying to graph the frequency of a series of cap rates but want to also show the average age of properties that have that cap rate. For example, the chart will show there are 3 properties with a 6.5% cap rate, 6 properties with a 6.75% cap rate etc. but I also want to see the average age...

Hi, Building a dashboard and displaying lots of charts. However sometimes the use might need to see all the details. The details not displayed on the charts. Is there a way to click on the chart or a column/line on the chat and get back to the full details? FYI - all these charts are tied...

Hi, I have created a Pivot Chart with Slicers etc. After the user selects the date ranges and filters. IS there a way to then export that view to a data table? Kinda of like in a regular pivot table you can click on the totals and then get the raw data related to that number? My users are...

Hello all I would appreciate some help with an issue that's been bugging me I made a dashboard with a bunch of slicers and pivot charts. All chart data is in the power pivot data model, there are no pivot tables anywhere in the file. As I am using the dashboard (adding data to model, using...

I keep getting the following error when I try to refresh a pivot table (not Power Pivot). "We couldn't get data from the Data Model. Object reference not set to an instance of an object". I tried re-selecting the data source, but would get the same error message. I checked to see that I have...

Hi everyone, I've got a problem where my solution just isn't good enough and I'm hoping someone will have a better idea. The problem: I have to report vehicle utilisation by month, by region, and by "category" (front line, second line, specialist, and average). I need a line/bar graph that...

Hi Hopeing someone can help - I've looked around on the internet but I could not find anything about moving pivot charts - just moving pivots tables I'm trying to copy a pivot chart (just the chart) to another workbook so I have the pivot table on one screen and the chart on another. I'm...

Does anyone know how (or if) I can change the default font size of the tick labels on the vertical axis in a Pivot Chart? This is easy to do in a standard chart, but for some reason, the option isn't presented (at least not obviously) on a PivotChart. I searched the interwebs and found the...

I am stumped by a question on a potential employer's Excel test. The objective is to create a graph showing each particular product's percentage of total month's sales, for a 12 month period. The data set is thousands of lines, each showing sales for each month for a particular product in a...

I have written this code and and the labels for the charts appear outside the graph area. I want to position data label inside the pie charts. How to do that ? With oChart4 .HasTitle = True .ChartTitle.Text = "On Net/ Off Net (Overall)" .ShowAllFieldButtons = False .ApplyDataLabels...

I would like my date axis in a 2013 Pivot Chart to graph proportionally based on the dates in my data set. I know how to do this without a pivot chart (using scatter plots), but I am unable to do this with my pivot chart. Let's say I have sales data for: Col A : Col B 1/1/2000 : $100...

Hi Guys, Would someone be kind enough to change my code so that the sheet the pivot tables are created in has a specific name (make it whatever you want). Through the rest of the code it should then reference back to this name. The reason I want to do this is due to the fact that my code below...

Hi, I have to create personalized compensation statement for each of our employees using word. There are 150 employees. I input their salary and fringe benefits into an excel spreadsheet for each employee and then do a mail merge. I did this last year by: 1)Creating a pivot table 2)Creating a...

Hi, Can someone help in vba coding to assign to slicer in power pivot report.I have a slicer with blank values coming. i have to hide those blank values. My Model is SSAS tabular model . Since the tabular model wont support outer join these blank values are coming in the slicer. ie, i have a...

Pivot chart formatting changes (title position, size of legend box, positioning of values on pie chart) - won't save :( Workbook is password protected. 3 Pivot charts created off 1 data set. Excel 2013. Please help! :eeek: Thank you!

I have a lot of graphs connected to specific Pivot charts. The Pivot Charts are refreshing when I enter in new data but the graphs connected to them will not refresh when I hit the refresh all button. I go to the graph and click the "Analyze" tab and everything is grayed out and will not let me...