pivot charts

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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!
  17. 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...
  18. T

    Pivotchart exclusion of low number occurrences

    I have a table with 2 columns of data. Column A has a broad description ( body, electric, plumbing, etc). Column B has a more complete description within each broad description ( 12( if next to body means crack)(if next to electric means something else), 39(if next to body means no weld). I...
  19. 3

    Creating Graphs From Pivot Tables Using Macro

    Hi there, I'm fairly new to recording macro's. I've attempted to create one to consolidate some data, then create a pivot table from this, and lastly, create a graph from the pivot table. The macro appears to work fine all the way through, until it comes to the Source Data for the Graph. I've...
  20. D

    Pivot Chart - Footer?

    Probably a dumb question - but is it possible to put headers and footer in a pivot chart? I know this is possible to do in a regular chart but not having luck trying to do this in a pivot chart. Thanks

Watch MrExcel Video

This Week's Hot Topics

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
Top