Forum

Hi Mariena, I'm not sure why you can't drag another field into the line field. I was able to. You just left click and drag until you see the yellow...

Hi Alan, I'd say if this has worked well for months then the date in the file must have been text format. Now the date in the file is a proper date...

Hi Maride, Welcome to our forum! You will have to split the dates into separate columns. Then you can subtract the start date from the end date ...

Hi Aye, I would go back to HR and insist on them providing you with a file with the columns in the same order every time. They should create a quer...

In that case I'd say there's something installed on your PC preventing the functionality.

Hi Austris, Currently you cannot refresh Power Query queries in Excel Online. Eventually you'll be able to, but we can't yet. Mynda

Hi Mark, Great to see you're making progress. You can use dynamic named ranges linked to your drop down list to switch the data displayed in the ch...

Hi Steve, Usually when strange things like this happen I reboot to see if that helps. Mynda

Hi Angela, Welcome to our forum! It's difficult to say how to fix the issue without seeing your file. Mynda

Hi Mark, There was no attachment (you need to click 'start upload' after selecting your file), but I had a look at the link and that looks like you...

Hi Zineddine, Great question, however I don't know of any resources that teach this, sorry. If you have a Microsoft 365 license then you can use th...

Hi Mark, Welcome to our forum! Do you mean like a dumbbell or lollipop chart? Mynda

Hi Mariena, No image attached. You need to click the Start Upload button after selecting the file, then wait for the grey check mark beside the fil...

Hi Tim, I'm not aware of any way to prevent this. However, you could set up some conditional formatting that checks the value entered into those ce...

Wow, thanks for your kind words, Simon! I've trained myself to pause rather than um-ing and ah-ing. Pauses are easy to edit out, whereas ums and ahs t...