pivot chart formatting

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

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

Hi Guys, I hope you're all keeping well! I was wondering if anyone else has seen this issue and has a solution I can use. For some reason, one line in my pivot chart keeps reverting to multiple arrows whenever I refresh. I end up having to use "Refresh Match Style" to return it to it's default...

I created a chart to compare 2019 vs 2020 by month. I dragged the values into place so months lined up. When I dragged Jan to first column I son't see the data. Any ideas? Office 365 Pro

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

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

So I have 3 worksheets that each have a number of pivot charts on them. The pivot data is on a different sheet than the pivot charts. Charts and Data are on separate sheets. I have a number of slicers (4) on each sheet too .... all three sheets have the same slicers so that if I make a change...

Hello community, I created a table PivotChart where I am comparing expenses from this year and last year month by month. I would like my bars to be filled with a different color depending on the difference with the previous year. For instance, if I have spent more in January 2018 than I did in...

Hi How can I maintain the same colour for each series in a pivot chart, when displayed alone or with other series as I change my slicers choices? Thanks, Tamir