pivot charts

  1. M

    Turn day over day data into pivot chart filtered by name

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

    How can I create a pivot chart with two line graphs?

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

    Overlapping labes on Pivot Charts

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

    How can you get raw data from Pivot Chart?

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

    Combining Fields in Pivot Chart

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

    Click on a pivot chart and get the table data ... Possible?

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

    Get Data table from Excel Chart (pivot chart)

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

    Pivot charts randomly switching data ranges

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

    Error "Couldn't get data from the Data Model"

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

    Calculating averages for a graph - just like a pivot

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

    Copy Pivot Chart To Another Workbook & Keep Links

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

    Changing the font size of Axis Tick Labels in a Pivot Chart

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

    Excel Test - Create trend line from data set

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

    Chart data label position

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

    Date-Based Axis for Pivot Chart Excel 2013

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

    Please help change my code!! VBA Code to generate pivot table and charts on a seperate sheet

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

    pivot chart inserted mail merge in word

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

    power pivot : vba script on slicer to hide certain values/ to restrict slicer to show only certain values.

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

    Pivot Chart - changes within charts won't save

    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!
  20. J

    Refreshing Graphs

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back