Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: May 14, 2025
Topics: 0 / Replies: 4762
Reply
RE: Quadrant chart - show Value from cells labels on hover

Hi Victoria, You can either manually drag them away from one another so they have more space, or you can use this technique to give the labels more...

2 years ago
Reply
RE: Office 365 - using comments or notes?

Hi Dieneba, Comments or Threaded Comments is their official name are the new improved notes. They kept notes in Excel for backwards compatibility, ...

2 years ago
Forum
Reply
RE: Unlocking free template - Interactive Excel Project Management Dashboard

Hi Bayar, If it's my Excel Project Management Dashboard, then there isn't any password protection on it. Mynda

2 years ago
Reply
RE: Standard list in Power Query

Hi Dieneba, You can try loading the 'Document' that comes up when you connect to a web page. This is the HTML code for the page and from there you ...

2 years ago
Forum
Reply
RE: Excel what if scenarios

Hi Dieneba, What if scenarios are covered in our Excel Analysis Toolpak course, but there is a written tutorial here on our blog: What If Analysis ...

2 years ago
Forum
Reply
RE: Power Query data from the WEB

That's the correct way to learn, but sometimes due to regional settings we need to use other techniques, so don't be afraid to reach out if you get st...

2 years ago
Forum
Reply
RE: Power Query data from the WEB

Hi Dieneba, Thanks for sharing your file. Riny is correct, this is most likely a locale issue. You need to use Change Type Using Locale as explaine...

2 years ago
Forum
Reply
RE: Power Query data from the WEB

Hi Dieneba, Can you please share your Excel file that has the error? Mynda

2 years ago
Forum
Reply
RE: Power Query data from the WEB

Hi Dieneba, I suspect you missed the step where you replace minus ( - ) signs with blanks before changing the data type to decimal. BTW, I've mo...

2 years ago
Forum
Reply
RE: Investment spreadsheet

Hi and welcome to our forum! It's great to hear you found my videos helpful The built in STOCKHISTORY and stock data types tools can't get your da...

2 years ago
Reply
RE: How to use a horizontal data table with date headers to pivot table

Hi Kenneth, You can use Power Query to unpivot the first table, and then use PivotTables and Slicers to summarise and filter the data according the...

2 years ago
Forum
Reply
RE: Power BI import of data file via a URL

Hi Tim, If the file is not already saved on OneDrive or SharePoint then you can't use a URL to download it via Power Query. You'd have to use Power...

2 years ago
Forum
Reply
RE: Excel formula

Hi Stephanie, It's great to see you're trying different things. When you make attempts and get stuck, it's best if you can share your file with you...

2 years ago
Forum
Reply
RE: Interactive Excel Project Management Dashboard

Hi Sebhattin, Using the example in your file, if you wanted the time bars for Angelini Drehbank coloured purple, you'd use this formula in your con...

2 years ago
Reply
RE: Excel formula

Hi Stephanie, The UNIQUE function (to generate the distinct list of objects) is covered in lesson 3.62 and dynamic named ranges are covered in 3.75...

2 years ago
Forum
Page 29 / 318