pivot chart

Hi so i will try to explain this the best i can, When i create a pivot chart it doesn't plot the values that are in the pivot table. i have a data set of two variables (different groups of universities) and then years 2007-2017 in a pivot table with values of student numbers. I have selected...

Hey! I'm in a bit of a pickle. So basically, I've got over 50,000 lines of columns that I have to convert to charts. And to test it out, I used a pivot table and chart. Everything works fine, but it doesn't detect seconds. So, what I did was: In raw data convert the text to columns as DATE...

Hello, I am using VBA to change the source data of a pivot cache which has several pivot tables connected to it. When the program runs, it connects the "main" pivot table to the new source data and then matches the remaining pivot tables to the "main" pivot table's index. Each pivot table has...

I am running a PivotChart (a line chart) and I want to identify the last non-blank datapoint for each series. The problem is that in a PivotChart, each series has the same number of datapoints (i.e. 10) even though each of my series in reality is different in size ... it's just that the...

Hi, I am hoping someone can help me with a problem that I am having with formatting on a 2 pivot charts that I have set up. I have set up 2 pivot tables that are showing trend data over a whole year for 15 different areas. I have used the slicer to flick through the different areas. The chart...

Respected Seniors! I am using the MS Excel 2013 pivot bar chart to to show some information on yearly basis. I have used the year values as "filter". Everything is working fine, except that I want to restrict the filter selection to one value (i.e. year) instead of multiple values selection at...

I am hoping someone can help me with this issue. I may not be explaining this very well but hopefully someone can decipher this for me. I have been looking everywhere to see how it would be possible to add data to bars in a pivot chart from related data. If you look at the attached image, I...

Hi All, I have a pivot Table/Chart that is sorted into hours/days/months. I need it to be separated like this as I need to identify values that go over a certain level but the average would give a false value on the chart. What I need to know is if it is possible for the horizontal axis to...

Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how...

I am hoping I can get some help with this issue on here. :confused: I have researched, but to no avail. I have created a dashboard using PivotTables/PivotCharts to show trends in payroll. The Dashboard has 8 different graphs on it that are controlled with 4 different slicers. When the...

What is better for memory management pivot tables that feed into a dashboard for slicers and pivot charts or a dynamic drop down list that populates the same information to a chart? I was also wondering does anyone have a solution to auto-refreshing a pivot table and pivot chart when new data is...

Hello, I have a pivot table that has values for every hour through the year. I have my pivot table set up so that the horizontal axis splits every hour up for each month. ie you would see | 0 2 4 6 8 10 12 14 16 18 20 22 | 0 2 4 6 8 10 12 14 16 18 20 22 | ..... |...

Hello folks, You all were very helpful before, so I wanted to take the time to ask the group how to best tackle a project I am dealing with. I am trying to get a dashboard working with Slicers on it. Not a big deal really but I am having trouble configuring it properly with stacked columns...

Have a pivot chart with some series titles in the legend that I want to change. I click on the series, go to Analyze in the Pivot Chart tools, go into the Active Field and edit the name. One series works just fine, but the other one won't keep the edited name. It just reverts to the original...

Happy New Year Everyone! I am having an issue with my report and I am not sure how to go about it. I have an excel report with 20 tabs and the 1st Tab is the summary overview tabs which has a few pivot charts. What I would like to do is when you click on the pivot chart on the summary page it...

I am trying to create a macro that automatically updates the y-axis min/max for two different pivot charts that are on the same sheet. I have 50 sheets in my workbook that I need to do this for. Does anyone know VBA for this? Thanks, Claire Using: Excel 2016 Windows 7

can you help me the with VBA code auto refresh the pivot chart . "Input Values " the name of sheet where i put the data "Dashboard" the name of sheet where pivot chart. i want when i put the data into sheet "Input Values" the Pivot chart auto refresh. if you are able to provide me the all...

Hello, I have been charged with creating an interactive pivot chart which calculates the frequency of census values. What I have done is used the census table to generate a census per day. From that I am trying to get frequency. To thwart confusion, frequency is defined...

All my data are captured in row series and not able to plot pivot table and chart as it involves several different tables example shown for one year bu this data continues for 5yrs need help for 1. i want to plot pivot table and chart for the first set of data format 2. if i plot for one...

Hello - I have a pivot bar chart with about 2500 labels (business addresses) when all records are unfiltered. This requires the frame of the bar chart to very large/tall. I also have slicers tied to the pivot chart that can substantially filter the records down... all the way to one record...