Forum

Hi Lynnette, Sorry I missed your question, so this reply is slower than I'd like. There's no ideal way to do this. This post offers a solution o...

Oops, sorry about that. Here is the correct link.

Hi Tracy, It won't be your laptop that's the problem. When slicers/filters remove series from the chart, the custom formatting is sometimes lost, w...

Hi Danielle, There's no SAMEPERIODLASTWEEK equivalent, but this post has a solution. The WEEKNUM function is explained here. If you can't wor...

Hi Andrew, I'd do this with Power Query. You can 'merge tables' and match people in your source data to the 130 job titles list and filter by date....

Hi Pam, Thanks for sharing your file. The best way to automate the aggregation of this data is with Power Query. This spreadsheet as it is will ...

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

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

Hi Pam, Please share your file so we can help you. Mynda

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...

Glad the workaround fixed it

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...

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

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

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