pivot chart

  1. J

    Dashboard insights and presentation

    I'm struggling to do a few things with regards to developing actionable insights and presenting in an easy to use dashboard for a wide user group. The situation is as follows; I want to Create a hierarchy dashboard across a number of kpis. I.,e start at the president's view of the average...
  2. K

    Averages in pivot charts

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

    Converting raw data to pivot table/chart doesn't detect seconds

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

    VBA Pivot Chart Colors

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

    Identify last datapoints in PivotChart

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

    Problem with Excel Pivot chart formatting

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

    Pivot Chart Filter Drop Down: Restrict Selection of One Value At a Time

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

    How to include two values in one bar for Pivot Chart

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

    Pivot chart customise axis

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

    How to group employee experience numbers 11.03, 0.11, 10.00 in pivot table and then it should get the count

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

    Excel 2016 Pivot Charts not all printing

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

    Memory Issue " Pivot Tables vs Dynamic drop down list

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

    Changing text, with Pivot Charts, with multiple horizontal axis

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

    Reconfig a Slicer Button to add multiple Cells to Dynamic Pivot Chart for a Bar Chart

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

    Series Titles (Legends) on pivot chart won't update after edit

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

    Pivot chart on summary page, link through to tab location...help :(

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

    Excel VBA - Automatically Adjust Pivot Chart Min/Max

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

    Pivot Chart Auto refresh

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

    Statistical Analyses Within a PT

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

    Not able to plot pivot table and chart for row data

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top