Видео

Thanks for this great video, hope you found the solution for inserting the axis if not, I've figured it out by changing the axis to x=180, y=90% as it will fall in the middle of the chart, then select it and add "Error Bar" percentage, change it to 100% for each, and finally delete the dot in the middle and there you go 😇

Nice tutorial!

THX

The trick at the end is quite useful. But the banded rows remains white+ formatting. Is there any way to color the white cells as well?

Amazing job and thank you for the help, exactly what I was looking for!

Thank you. Surprising that it takes this much manual effort. Excel should do better. Still, I appreciate you!

ask your boss for the think-cell add-in!😅

Amazing video. One question: When you made the scatter plot comparing tenure and salary, you mentioned that in a mathematical world you would see a 45 degree line. Is it safe to say that the 45 degree line is an industry benchmark or a goal to try a reach to? That question excludes performance.

You’re a life saver! Thank you so much!

Wow! This is helpful🎉 Thanks.

i followed the instructions and copied the process and "code" given , but this doesn't work on me can you help me with this? the target value does not show up in the specified cell of selection.

Hello :) I'm wondering if you can show us how to add a horizontal line for the average for each of the colour groups (for example y = 0.2 for the 'new' tenure category in your video)

Great solution, Tnx.

Is there a way to add a filter to this

wtf????

Brilliant presentation and guidance. Thank you

great video thank you very much

the video is blurring

Thank you so much! This just saved me! 🙏🙏🙏

Excellent. Thank you so much!

tysm for the info:)

bars are on the left, the scatter is far to the right - something is missing

If you want dividers for the 4 quadrants, that adjust according to the average of the Salary (X) and Comp (Y) values, then use Error Bars, as follows. Add a series to the bubble chart with a single point, where X and Y are the average of Salary and Comps.Then format the bubble so it is hidden (no fill, no border) and add X and Y error bars which have values that you adjust so they reach to the edges of the chart. Thanks to Jon Peltier, aka Mr Excel for this technique.

hi after 5 years, i again come back to ur videos for solution. i lost the code once i created at that time and now i am searching out how i have did that. what i am trying to do is.. first filtering the row on basis of certain cell, after that automatically save to pdf keeping the file name same as the filtered data cell value. and continue till the last row.. can you help

Great video. Note that you can make the title dynamic by clicking on the title and then go to the formula bar and reference the cell by using = eg =b3 will put the value of cell B3 as your chart title

for me all working fine but except deleting filter column which i dont want

Is there a way to replicate this in PBI? Management loves this graph and having difficulty replicating in PBI

Thank you.. its very helpful explaination

Its not working

Excellent! Great tip especially to those like me starting to write and work with VBA macros.I like how you explained in detail each step and also how you show them through the script. I'm really looking forward to more of your tips.

If a new person joins the company, do i need to manually create a new radar chart for that person? Is there a way in Power BI to create the new radar chart automatically when new records for a person are added?

You are very kind to share, thank you.

Helpful, thanks

The font in vba editor is too small

Data manipulation at its finest...

how to do it for the stacked bar chart

Such a helpful video!

thankyou for detailed explanation

thanks a lot ma'am, great work. once again hearty thanks....

Very helpful.Thankyou ❤

Isn't there any shortcut that mark the exact middle point on X or Y axis?

How to decide expexted percentage and how to calculate actual result based on your video.

Do you know why my sumifs does not work in sharepoint?

Your tutorial is very helpful. However, while i was trying it, i could not get the columns and points to align. I was able to create a floating bar chart following your tutorial. I have 5 grades. However, when i was already incorporating the individual salary in the salary structure, the points and the columns do not align. The columns went to the far left of the chart and became thinner even if i adjust it using Format Data Series. Dont know what i did wrong.

In master data i have different headings....

Hello, great information. Am interested in the template

very helpful, thank you!

Can you explain more on compare-ration figure?

Hi Techer, may I ask how to add the ID near the floating point?

Thank you so much for sharing.