Hi Hui,
Do you mean I have to manually format 192 data points? When I add data to any of the cells, many more data points are added to the chart - I don't need 192 data points on the chart, just 1 point to represent 1 value.
I found a VBA that comes close to what I'm looking for...
Hi everyone!
You have given me incredible solutions to my previous question, and I hope you can once again help me out here!
1. I want to create a chart that looks like the attached PDF file. I used scatter charts, and added labels as text boxes for the x-axis. So far, so good.
2. I have...
Hi,
I am creating a form that displays some content in a dynamic text box. The text box is linked to a cell with a simple =$A$5 formula in the formula bar. The linked cell ($A$5) has a formula that picks the content to be displayed.
However the textbox is only showing me a part of the...
Hi everyone,
My team has requested for another level of detail in our dashboard- they want to be able to see the data points behind the numbers.
For example, if the data shows 3 employees in Hong Kong, they will click on the number '3', and the names of the 3 employees will show up. It's an...
Hi Narayan,
Thank you, thank you, thank you, thank you, thank you!! I copied the formula for regional leaders, and changed the "-2" to "-20", since my Supervisor Level 1 starts from Col R. It works beautifully!!
This is a flexible solution to a problem I have been trying to fix for months now...
Hi Narayan,
It works perfectly for me in the sample file, but in the larger database, there is a #REF! error if I consider more than 4 levels in the Index range.
Also what does the "-2" do?
I'm uploading the file again. I've left the output columns blank (though we have a solution for Team and HRBP). I've added a new column showing what the regional leaders column should display (the output I want).
Yes, that is a mistake, I should have selected the Level 4 leader. I just pulled together some dummy data, and did not check the file thoroughly. This is the problem with my formula being fixed to a particular value in a particular cell.
Thank you for your time and patience!
I need a formula for Regional Leader in my first table (I can definitely use your solution for the Team and HRBP columns). I calculate this information, based on the data in columns C to I.
The If logic is something like this:
If the last level...
Hi Narayan,
Sorry, let me try again. The file shows my solution using nested Ifs.
In the Database table, Emp ID, name, and the supervisors, from level 1 to 7- are pulled from a report. I fit the employee to a team and leader, and enter that data in Leader, team and HRBP columns.
The second...
Hi,
Our employee file has the hierarchy of supervisors, from the CEO down to the first level supervisors, across multiple columns. I have 60+ leaders, representing 30 teams, and supported by 10 HR business partners. I have to map the regional leaders based on the the sequence of supervisors...