pivot chart

  1. outlawspeeder

    VBA Is there an easy way to recreate new pivot charts

    I building a way for a worker to paste 5k line of info, clean it of $^!$@#$^% and then build a pivot charts (more than one) I recorded making a Pivot chart. It names the the chart +a number. Mine as recorded is 4. If I use this code again I get an error. I tried make a variable and replacing...
  2. M

    Excel Chart - number formatting as decimal only if decimal values are available in source data

    I am having chart based on power pivot where values for all the months are updated based on slicer Selection. (E.g. Profit, Profit%.) I am currently using this number format "#,##0_);[Red](#,##0)" for chart labels which is available by default in excel. This format hides decimal values...
  3. I

    Create Pivot Chart without Pivot Table

    Hi all, I am new to this forum and I have been researched about if it's possible to create many pivot charts without each being generated from an individual pivot table? My end goal is to publish a excel dashboard to demonstrate the price change of different material cost over time. The data...
  4. S

    Show Items With No Data Not Working the Same Since Nov 2022?

    I have a spreadsheet that I haven't refreshed since the middle of November 2022. When I refresh the data today, the chart shows every month instead of only the filtered month! Has something changed in excel since November 2022? This used to work, but now doesn't, and all I did was RMB...
  5. C

    Setting vertical axis in dynamic pivot charts and slicer button positioning without VBA

    Hi Excel Gurus, After a week of googling, reading and trying. I am giving up to ask the experienced members of the community to please help me out. I am using a pivot chart slicers with dynamic charts with multiple outputs. 1. How do I force the vertical value axis to be the same for each...
  6. X

    Separate Pivot chart for each Pivot table sheet from "Show report filter pages"

    Hi, I created 20 pivot table reports on separate sheets - 1 for each department - showing compensation for staff members in a team from a data table using the "Show report Filter pages" features menu in Pivot tables. Is there a way to automatically create separate column charts on...
  7. M

    Pivot Chart Legend/values Slicer?

    Ive got a pivot line chart, with multiple values represented through lines. Is there a way to make a slicer for the values/legend? Id like to turn some lines on/off without having to remove/add them in the values area.
  8. X

    Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  9. 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...
  10. Kobi Merrikin

    Custom Sort on Pivot Chart

    Hello! I have a simple pivot chart collating some totals for figures in each month of the year. I would like this to display in the month order (Jan-Feb) but I am unable to manipulate the source data so it reflects this. Is there another way to do so? I do not have an option to use the custom...
  11. B

    Excel Pivot Chart add Horizontal and Vertical Lines

    So I have tried a couple of things and ran into a couple of problems. First of all my desired situation: I have a Pivot Chart based on data which contains Dates, Values and Locations. (A2A, A4A etc. are locations). I want to have a legend based on the different locations so I can see which...
  12. G

    PIVOT TABLE + CHART - Pasting Special Values making Pivot Chart Blank

    Hello all, We have one pivot table where we are seeing a recurring issue - this does not happen with any other pivot tables on the tab. I am trying to paste+special values on the pivot table so it removes the link to source data, and will then leave me with a graph. This seems to work for any...
  13. 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??
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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