Forum

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

Hi Rasit, Welcome to our forum! I think Named Sets can help you. Mynda

Hi Jacqui, This formula will give you a list of Thursday and Friday dates where A1 contains the first date you want to start at: =WORKDAY.INTL(A...

Hi Jacqui, It depends on whether those workdays are sequential or not. e.g. are they Monday and Tuesday or Monday and Thursday? Also, please confir...

So the problem is that you can't get a PivotTable to display in the layout shown in the Template sheet. If that's the case then you'd need to write so...

Hi Alison, Unfortunately, the file doesn't really help me understand why the 'Show report filter pages' tool doesn't work for you (I honestly think...

Hi Peter, Have you see this tutorial on scraping data from multiple web pages? I can see from the URL structure that you have parameters in the str...