pivot chart

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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