Forum

Hi Justine, Please upload your sample file. You need to click the 'Start Upload' button after selecting your file and then wait for the grey check ...

It can't be done in the PivotTable, sorry.

Hi Kenneth, If you have Microsoft 365 you can use this formula: =TEXTJOIN(", ",TRUE,FILTER(A4:A10,(ISNUMBER(SEARCH(B1,B4:B10))+ISNUMBER(SEARCH(B...

Hi Dieneba, Welcome to our forum! The Insert Data From picture feature is only available with 365 for Mac, Excel for iPhone and Excel for Androi...

"Bar charts only have nested axis labels for Pivot Charts or regular bar charts with more than one row of axis labels." In other words, you have a reg...

You need to do this in the Power BI model. Ideally this should be done in Power Query where you set the data types.

Hi Velouria, Not sure why you see something different. When I edit the chart references I see the axis labels are pointing to: ='New-Metrics-Wor...

Hi Mark, Welcome to our forum. PivotTables aren't designed to work that way. If you collapse the year it will show you the year total as you've fou...

Hi Yuan, That's an interesting problem. I can't see what's causing it, sorry. Mynda

Hi Shawn, 1. The formulas for your named ranges are correct, although you don't need the IF(COUNTA(... A more efficient way to write it is using IF...

Hi PA and welcome to our forum! Have you tried using Slicers or Timeline Slicers to allow the user to select different levels: days, months, quarte...

Hi and welcome to our forum. I wouldn't classify Power Query as a watered down VBA tool. It's a dedicated ETL (Extract, Transform and Load data) to...

Hi Shawn, Thanks for sharing further information. 1. I'd say the VBA is specifying the axis labels when the 'Refresh Chart' macro is run. There'...

Hi Patrick, The 'value if false' argument is omitted and your formula is incomplete, so I'd say that's causing the problem as it's going around in ...

Hi Doug, Looks like you're in Excel Online. There's no Power Query editor in Excel Online yet. Mynda