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

    Excel slicers

    excel 2019 latest version
  2. J

    Excel slicers

    Hi Thank you for the response. Please find attached sample template with the desired output. Let me know for any clarifications. Regards Jaya
  3. J

    Excel slicers

    Basically I need one slicer in the whole dashboard but the pivot/graph selection is based on 4 week for few graphs and 1 week for some of the graphs.. Is that possible? Thank you Regards
  4. J

    Excel slicers

    Hi, Request your help/suggestion. I wanted to know if there is a possibility that the excel slicer linked to graph few graph showing(connected) multiple selection and the same slicer can change the graph with one selection. The same slicer being linked to multiple graphs but the graph...
  5. J

    % of running total in

    Hi Folks, Request your help on the posted thread... Thanks in Advance. Regards Jaya
  6. J

    % of running total in

    Hi, Is there any way of adding pivot to the data and linking to the graph as attached. I have attached a sample copy of the file with the desired output. I am looking a way out for automating the desired output with the help of pivot and graphs. Any help will be appreciated. Thanks
  7. J

    Auto birthday emailers

    Hi All, I am working on to send auto birthday emails from excel through outlook. I have a list of entries where the DOB and email id's are mentioned. I need the macro which auto send the emails as an when its the current date without any reminders or pop up emails. Its just that if in case I...
  8. J

    ignore 0 values in the graph when the range with formula output is zero

    Hey yes something of this kind but I already have formula in my GBS and KH area. Can you help me with this file
  9. J

    ignore 0 values in the graph when the range with formula output is zero

    Hi Team, I am looking out for the solution to ignore 0 values in the graph when the range with formula output is zero(in bar graph). Please find attach the screenshot. I dont want to chch and LBC in my chart as there are no values for it. Looking out for auto option. And my range is Any...
  10. J

    Graph range help!

    Hi Team, I want to display no bar(data) in my graph if the data range is blank or 0 zero value. In the below case i only want to show Northgate bar excluding the rest. Manually it is possible by selecting North gate range only. What if i want to keep the whole range in the chart and exclude...
  11. J

    formula for pivot calculation

    Yes you are right..they are not linked to pivots. But the numbers are picked up from pivots. I had created 4 different tables for the same(In the filter option country should be AUS and category should be Payroll management and the same for NZ as well. As of now I am doing it manually. so I am...
  12. J

    formula for pivot calculation

    This seems to work fine. But actually, in my dashboard there are 4 different graphs for which the numbers comes from the above pivot, eg. AUS -Payroll management and AUS - Talent & services and same as for NZ. so can u help me achieving that results. I need to link that tables to graph may be i...
  13. J

    formula for pivot calculation

    Thank you both:)
  14. J

    Dynamic graph with dynamic pivot

    Thank you GraH :)
  15. J

    Dynamic graph with dynamic pivot

    Hi Thanks for your reply. It seems to be working fine.Can you please let me know what you had done to get it. One more thing, I can see is the select data range for the graph seems to be greyed out. Regards Jaya
  16. J

    formula for pivot calculation

    Thank you for your reply. It seems you have linked the formulas with the pivot table as when I change the country to New Zealand. It is not coming up with proper output. It would be better to update or link formulas based on the Raw data sheet according to the pivot table filter criteria...
  17. J

    formula for pivot calculation

    Hi Team, Request you to help with the formula calculation in the attached sample file. Also, is there a way to use the shared file (formula table) in my other excel dashboard workbook. Regards Jaya
  18. J

    Dynamic graph with dynamic pivot

    Hi Team, Please help me with a solution to automate the graph with the pivot data without using table. My graph needs to be refreshed when the pivot data changes. VBA macro solution is also fine. Please find attached the sample file for reference. Thank you in advance. Regards Jaya
  19. J

    Power Pivot Add In Missing

    Hi If you have recently upgraded to Excel 2016 and don’t have a Power Pivot tab available to you, there are a couple things you can do. You might want to go to the Developer tab and click on the COM Add-ins icon, which will display a list of the Add-ins available. If Power Pivot is available...
  20. J

    Make formulas more manageble

    Hi Please find attached. Regards Jaya
  21. J

    Count if with AND conditions

    Hi Ateeq, Something like this.. =IF(AND(B1=9028,D1="Khanewal",E1=12),COUNT(E1:E3),"") Regards Jaya
  22. J

    how to use if function in Condition formatting cell

    Hi Naresh, Welcome to the Forum!! Firstly the result what you had requested is not possible through conditional formatting. You can apply conditional formatting using values and format it to expected color. But you can put/show values based on colors. For eg: if cell have green color then...
  23. J

    Refresh all Pivot Tables

    Hi Dokat, Please try the below code: Sub RefreshAllPivotTables() Dim PT As PivotTable Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets For Each PT In WS.PivotTables PT.RefreshTable Next PT Next WS End Sub Note: It will refresh all the pivots...
  24. J

    Help with Formula

    Hi, Can you please share the excel file so that it is easy to work. Also show the expected results in the particular field so that it is easy to help you. Thanks Jaya
  25. J

    Send email from Excel if the condition met

    This is what you are looking for? Please check the attachment. Regards Jaya
Back
Top