pivot chart

  1. O

    do not allow moving/selecting/editing pivot chart but allow the user to use the filters of the pivot chart

    Hello everybody, i have a chart (created from a pivot table) and i want the user to be able to use the filter on the chart but to NOT be able to edit, copy or move the chart. Is this possible??
  2. D

    Permantly change font size for "data-labels" in a pivot chart

    Hello everyone. This is my first post on the site, so I hope my question is in compliance with the rules; Otherwise I apologize. Anyhow, I'd like to know, if it's possible to permanently alter the font size of the data-labels within a pivot chart: I'm able to temporary alter the text size...
  3. D

    Refresh pivot table and report in protected sheets

    I have sheet-a, it contains pivots only, only allows select locked/unlocked/autofilter, and sheet-b, it contains pivot chart, only allows select locked/unlocked/use pivot table & report, sheet-c contains both pivot and report, only allows select locked/unlocked/use pivot table & report, some...
  4. S

    Pivot Chart not ordering in numerical order

    I have a power query column which has values from 0 to 20 for each month of the year and has USHolidays written in the field for USHolidays which then dumps into a table. When I chart it from the table using Pivot chart the numbers are not in order from 0 to 20 in the horizontal axis. I chart...
  5. W

    Pivot Chart - Two Filters on Same Axis - or Retained Styles

    I've tried a whole lot of different permutations of an admittedly fairly new thing for me in Excel: Pivot Charts. I have monthly data for four different players in TWO categories: Homeruns and Stolen Bases. Can I produce a chart, Pivot, combo, template or otherwise, that can filter: Players...
  6. F

    Counting streaks from an excel table

    Hi I am trying to track the reliability of vehicles within our fleet, every rota we complete an evaluation of the vehicles where they will be tested on various criteria and scored as a pass or fail (with a fail marking a 1 on an excel table). This data would be better understood by our...
  7. A

    Creating an Account Balance chart using a PivotTable from an imported set of Bank data

    Hi Chaps, There are a few old posts around stuff like this but nothing that i can find that seems to get to the crux of what the problem i am having... Bottom line - I want to be able to create a chart showing the balance in my bank account(s) over time Project Outline: - I have bank data...
  8. D

    Bubble Chart: Why is simple so hard?

    I have a very simple table of data... x-axis with "text definers" and y-axis with "text definers", and in the middle data... I just want to show a bubble chart with the x/y axis and the bubbles sized by the middle data. But, I can't define both axis. What am I missing? What can I use to do...
  9. Q

    Custom Filter Groups for Pivot Charts

    I have a dataset with about 25 columns that I would like to visualize in a chart. Because of the large number of columns, having them all show up at once would make the chart too cluttered. Is there a way to create a custom filter for the chart to show predefined columns? For example, "show...
  10. M

    Multiple Pivot Charts With Linked Filter

    I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection. What I am trying to accomplish is I have all 3 pivot charts displayed...
  11. S

    Chart set up

    Hello all, I was wondering if yall could help me with a chart organization problem that I have been having. I am not sure if it is better to set it up my charts as a pivot table or to use an original bar chart. On sheet one, I have in column A = names of employees, column B = Week of (Date)...
  12. W

    VBA to allow use of Expand/Collapse button on Pivot Chart, but Disable all Formatting Selection

    Hi! I have an obscure request. I do this thing where I like to use a pivot chart (with the expand/collapse button) as a fast way to "expand all" or "collapse all" for a related pivot table. Really, all I need is the Expand/Collapse button from the chart, so I always shrink the chart so I can...
  13. P

    custom error bars in pivot chart based on calculated field

    Is it possible to create custom error bars in a pivot chart that are based on a calculated field? I would like to create a bar chart representing PROPORTIONS with error bars that represent the CONFIDENCE INTERVALS. My data contains N items that either can be "failed" (0) or "passed" (1)...
  14. N

    Creating Pivot chart from Macro

    I have written a macro to create a Pivot chart in Excel in one Workbook. If I am running the macro from the same workbook it is adding the pivot chart proper without any error. But if I am running the macro from another workbook, I am getting the Application defined or Object defined error in...
  15. K

    Pivot Chart Color Theme Customization Possible?

    Hey All, Just a quick question I cannot find an article or answer to. I have a table of data represented in pivot tables/charts. It covers several call center metrics in a line graph format (Calls Offered, Calls Answered, Calls Abandoned). I want to set a monochromatic color scheme / year...
  16. G

    Data labels in pivot chart

    Hi all, I have created a pivot chart (line graph) and would like the x-axis to display all months (Jan-Dec). The pivot table linked to the pivot chart formatted to show a running total for each month. So far I can either show only months that have data (i.e - if I have data for Jan-Mar, I can...
  17. A

    Getting Pivot Chart to change yearly goals into month according to filtered team

    Hi Everyone, I have a data set of sales reps and their sales (date of sale, amount, team, etc). I also have a separate sheet which has goals for these folks for the full year. I've setup a pivot table and a line chart on the sales file that shows total sales for the year broken down by months...
  18. J

    Multiple Summary pages

    Here is an example of a dashboard I created and I need help merging multiple dashboards into one PDF in excel. https://pasteboard.co/HNV3cgL.png This dashboard is a summary for one employee, but we have 50 employees. To change the employee to another, I am using a slicer, which then changes...
  19. K

    Show both text & numerical values in pivot chart

    Hi! Trying to figure out a way to create a pivot chart where the value will show as "SUPP" if <= 9... anything >=10 will show the value... Any ideas?
  20. S

    Creating a Pivot Chart without changing the table

    Hi Everyone, I am just trying to make several pivot charts from one master pivot table I am using. each chart will refer to what is in the row. When I make a normal pivot chart and change the parameters within that, then it filters the pivot table and changes all the charts related to that. I...

Watch MrExcel Video

This Week's Hot Topics

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