Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Apr 19, 2025
Topics: 0 / Replies: 4761
Reply
RE: Two Headers not on subsequent rows

Hi Steve, For best results please start a new thread with your question. You can link back to this question in your new post. Mynda

11 months ago
Forum
Reply
RE: positive & negative graph

Hi Alexandra, Please try uploading your image again and also upload a sample file with your data so we can help you further. Mynda

11 months ago
Reply
RE: Dynamic Labels within Pivot or Regular Charts?

Instead of adding your labels as text boxes, use the data labels and reference the cells containing the label for each point. You can choose this in t...

11 months ago
Reply
RE: Line Chart with Slicer - Bug?

Glad the workaround fixed it

11 months ago
Reply
RE: IF/IFS

Probably, but it's difficult for me to give you a specific answer without a specific example. Can you please upload an example file that illustrates t...

11 months ago
Reply
RE: LET functions

Absolutely, please let me know what your question is and if you have an example Excel file that illustrates your question, all the better. Mynda

11 months ago
Reply
RE: Highlight Y-O-Y like Min and Max in a chart?

Hi Brenda, Congratulations on figuring it out yourself! Pivot Charts are too restrictive to create a chart with different points highlighted as ...

11 months ago
Reply
RE: Highlight Y-O-Y like Min and Max in a chart?

Hi Brenda, Can you please share the file, or if it's confidential, please create a mock-up that illustrates the issue. Mynda

11 months ago
Reply
RE: Connecting Excel Power Query to a Local Database System

Hi Mohamed, It will depend on the type of database. If it's SQL, then you can connect to it using the From Database connector for SQL databases. ...

11 months ago
Forum
Reply
RE: IF/IFS

Hi Sham, Great to hear you're progressing through the course. The best/most efficient way to do this is with a lookup formula. You can use VLOOKUP ...

11 months ago
Reply
RE: Calculate monthly movement from YTD balance

Hi Bax, I guess there are a few ways you can approach this depending on the information you have in the reports, but the simplest might be to separ...

11 months ago
Forum
Reply
RE: won't Disappear

Hold CTRL and left click on the outer edge of the text box, then press DELETE.

11 months ago
Reply
RE: Line Chart with Slicer - Bug?

Hi Tracy, Make sure you clear all the filters in the Slicers for the Chart before formatting. The formats should then stick. However, if the slicer...

11 months ago
Reply
RE: Dynamic array - splitting single column, replicate others

I would use Power Query to do this. Split by delimited and then in the Advanced settings choose 'by rows'.

12 months ago
Page 6 / 318