1. F

    PowerPivot, Running Totals, and Chart Lines with null data

    Good afternoon all, I'm certain that we've all had this issue at one point or another but I can't seem to find a solution--hoping that someone has something ready to go. Here's the summary: PivotChart with Date values on X AXIS and a Running Value Count 'flattens' when max is reached. The...
  2. G

    PivotChart formatting help

    Hi all, I have a fairly large dataset that is broken down as minute-by-minute data. I am plotting various charts from the PivotTable data, generally using averages. I have "Time" in the row field on my PivotTable, but when I plot a chart it gives me some strange time values along the X axis...
  3. L

    Excel (Office 365) not showing sorted Pivot Chart data

    Hi, I have just updated to Office 365 (Windows 10) so I have the latest 2019 version of Excel. When I create a pivot chart, the chart and PivotChart Fields are visible but the sorted data is not visible. I have never had this issue before (Excel 2013). With the older version of Excel, the...
  4. S

    VBA USERFORMS : Combobox values into Pivot Chart table

    Hi Friends, I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) . Please help me to create code for...
  5. C

    Pivot table issues

    Hi, I have created a template for providing monthly reports on financial figures. I paste 1x row per project in sheet(1), then I have 7x sheets with the exact information (they are all linked). To those 7x sheets I have 7 different pivot tables. When I update sheet(1) with new information and...
  6. H

    Can't use PivotChart controls on a Protected Sheet

    Hi there, I have created a sheet with pivot charts that I want to be locked in place, but have their filter controls remain useable. When I protect the sheet though and check 'Use PivotTable & PivotChart', the pivot chart controls are locked. Can someone help? Pete
  7. L

    PivotChart Filter not displaying

    I sent an excel file to my coworkers with a pivotchart. The chart has filters but some of my coworkers when they open excel can not see the Filters. Is there a setting somewhere in Excel that I can share with them to check to see if this makes the pivot chart filters display so they can use...
  8. T

    Returning SeriesCollection XValues individually (VBA)

    Below code, I use in a class module to return XValues from a chart whenever a user clicks on any data point. However, if the PivotChart has multiple category X axis labels, it scoops them all up and concatenates using space. e.g. if PivotChart will have columns "Continent", "Country" and "State"...
  9. J

    Can I add Chart label that is a count?

    Hi all, I have made a pivot chart and I would like to add a label above each bar that shows the number of records that make up that bar... I have the count in my pivot table and field list, but can't figure out if/how i can use it as a label without embedding into the chart as a series or axis...
  10. A

    Pivot Charts losing formatting when new data entered

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

    Pivot Chart displaying all drop down menu data

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

    PivotCharts from Excel

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

    Complex charting made simple

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

    Running total in - hidden columns in chart based on date

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

    Speedometer Chart from -100 to +100

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

    PivotChart - Stacked column and line chart issue

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

    Protect Pivotchart, but leave it selectable?

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

    Is it possible to save the history of a progress chart that shows the current state of a project, but it gets updated over time?

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

    Average of PivotChart values from a Data Model

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

    Changed Behavior Pivot-Chart & Error Values: 2007 to 2013

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

Some videos you may like

This Week's Hot Topics