• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Thank you so much Chihiro! I worked through the example link you sent to just understand the process which was really useful and then applied this to my main file as you described and it works great (after a few head scratching moments!). Really appreciate your time and assistance in this and...
  2. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Oops! I have loaded the file again without a password
  3. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Thank you! I have Excel 2013. In the attached file i have stripped a lot of my original data so and left just a few fields as an example. Tab 'Data' is my existing employees Tab 'Leavers' is my second data set of employees who left Tab 'HC Pivot' is where i have created the pivots that I want...
  4. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Thank you Chihiro. My Excel knowledge is good but i am not advanced and my VBA knowledge is very minimal so you may need to explain this to me. I'm not sure if the two sets of data can be related. They are based on employees - one set of data shows all the data for active employees and the...
  5. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Thank you for the links above xlstime. However, they address how to connect the slicers to multiple pivot tables when the pivots are all based on the same data set. What i have is pivot tables that are based on two separate sets of data. Both sets of data have some common fields like Country...
  6. K

    Pivot Slicer to work for pivot tables based on two sets of data

    Hi, I have been using pivot table slicers for a large set of data for active employees and everything works fine. I now have another set of data for employees who have left in another tab and have a pivot table based on this set of data. On my dashboard I am trying to show a summary of active...
  7. K

    Excel Chart Axis Scale from Cell

    Thank you so much Chihiro - that works perfectly! :)
  8. K

    Excel Chart Axis Scale from Cell

    Hi Chihiro. Thank you for the update but I am still struggling - mainly because I am not very familiar with VBA! I have attached a portion of the file I am working on which has the 6 charts that I want to have the same set axis. The changes are made via Pivot Slicers in the 'Summary' tab...
  9. K

    Excel Chart Axis Scale from Cell

    Hello Chihiro. Thank you for your reply and apologies for the late reply as I have been away from work for the last 2 weeks. I have tried to go through this and enter the VBA code but it does not seem to be working for some reason? In a tab named 'Summary' I have 6 different charts side by...
  10. K

    Excel Chart Axis Scale from Cell

    I have data in my file from which I produce a chart. Depending on the selection the user chooses from the drop down box, the data will change. I have a few charts based of this same data and I want the axis numbers to remain at the same levels. In the data, I work out the MAX value I want on...
  11. K

    Dependent Combo Box Control

    Thank you Narayan :)
  12. K

    Dependent Combo Box Control

    Yes, that is exactly what i needed. Thank you Narayan! Could you please let me know how you did it?
  13. K

    Dependent Combo Box Control

    Thank you for the link bobhc - I am no so great with understanding code - do you know if there is a way to do this without having to use VBA?
  14. K

    Dependent Combo Box Control

    I have attached the file - the left two boxes are the data validation lists and then i have added the first combo box which shows the regions.
  15. K

    Dependent Combo Box Control

    Hi, With the help of this site, i have figured out how to do drop down lists in data validation where the options that appear in my second drop down list are dependent on the choice made in the first list. However, i need to do this on an ActiveX Combo Box. I have a list of countries and the...
  16. K

    Find the non-blank cell in a range and display the value of the cell

    Thank you both for the formulas. The Index formula worked for most of the rows but some came back with error for some reason and i couldn't see why. The Lookup formula also worked - thank you!
  17. K

    Find the non-blank cell in a range and display the value of the cell

    Hi, This seems straight forward but i am struggling to find a formula for this. I have data in rows and not all of the cells have data in them. For each row, i want to look up the range (i.e. A4:F4) and return the value from the last non-blank cell. Could anyone please help?
Back
Top