1. S

    VBA question: how to highlight one bar color in pivot chart depending on cell value from drop down list

    Hello everyone! I want to highlight a bar red in a pivot chart based on what value is chosen from a drop down list. The values in the drop down list correspond to the x values in the chart. For example, if I choose Blake, Judith in the drop down list I want her bar in the chart to be red and all...
  2. L

    Time based graph

    Hi, Is it possible to create a time based graph in Excel where I can plot a bookmakers odds against the Timestamp (Timevalid) on the axis and the odds on the y axis? I would like to define which Bookmakers to include in a filter for the graph (is this a pivot graph?) as well as which selection...
  3. T

    Filtering rows in pivot chart

    Fairly new to excel. I have created a pivot table and organised it to display what I need. When creating a pivot chart, when I create a slicer I cannot filter the data/rows I want to view. It may be that I need to add something to the raw data or that I need to change my pivot table/chart...
  4. K

    Dynamic X Axis Based on Slicer Selection

    I'm trying to have my X axis dynamically update with the selection of the slicers, in a "pecking order". For example: If I select a year from the year slicer, axis will change to year. If I select a month from the month slicer, it will change to months within that year. If I select a day from...
  5. K

    How to add Data label in Stacked column chart of Pivot charts

    Hello friends, I'm tring to make a Pivot chart with stacked column graph. In where, i couldn't add data label for cumulative sum of value in Data label. Where i could only add data label to individual stacks in column graph. It found possible with normal stacked column chart without pivot...
  6. T

    VBA code to change chart type and axis for 2 series

    I am trying to change the chart type for 2 series. Series 1 should be a Column chart with the primary axis and Series 2 should be a Line Chart with the Secondary axis. I get a 438 error. WHat am I doing wrong. Please help. I am using Excel 2016 Sub Chart1_Update() Set wsPivotChart =...
  7. D

    Adding Grand total to Pivot Chart Table

    I have a Pivot chart which has Table in it. I need to add the total to the end of the table. Please help me to get it resolved. Pivot table Pivot Chart Need to add the total at the end as shown down
  8. A

    having problems with pivot charts

    Hello to eveyone I want to get a pivot chart from a table that the horizontal axis has subcategory and I really dont have an idea how can I make that how ever I can not specify categories to special axis ABCD1basement poylgonstarget ratiodisplacement(cm)Initial...
  9. K

    Field List for PivotChart and PivotTable

    Is it possible to create a PivotChart and PivotTable from the same information but display different information in each? I created a pie chart based on a PivotTable for an assignment, and when I moved the fields between areas like the legend and axis in the field list, it modified both the...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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...
  17. 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"...
  18. 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...
  19. 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...
  20. 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...

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