pivotchart

Can someone help me with dashboarding? I've got data where you can see who (Column 'Plant') did something during the month. I need to easily see during the month who did something that month/this year. And I want to easily see/select where it is not going great during the month/year. This data...

Hello excel experts, I am trying to create a chart that has the following "rules": - Plot months along X axis - Plot two columns: Current Year, Prior Year - Stack the categories that make up those total columns Is there a way to make this happen in a Pivot Chart? If I try to add Category to...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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