• 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

    diagram on dashboard

    Hi Chandoo experts: I was wondering if I can bug you regarding my detroit dashboard. On the batting dash tab, I inserted a diagram of comerica park where the tigers play. What I would like to do is whenever you choose a player from the slicer i would like to see where that player is played and...
  2. J

    Updating a Slicer

    Hi Excel Experts, I just want to ask a question regarding slicers. How do you update them? I have added another name to my table but when I see the slicer it is blank. What do I need to do to fix this? Thank you, Joseph from Michigan.
  3. J

    slicer question

    Hi Chandoo Experts, I am having trouble understanding the slicer connections. In the batting dashboard I have "Choose A Player" slicer that works nicely with my vlookup and the pt to the far left. I wanted to add the Players bio to the dashboard. When I look at the reports connection (The...
  4. J

    Detroit Dashboard

    Hi Chandoo Experts, I made a baseball dashboard of my favorite team. I was wondering if you can take a look at something. I created a pitching dashboard and a batting dashboard. The pitching dashboard works perfectly the way I wanted it to. The batting dashboard does not. Can you look at...
  5. J

    Adding names to the v look up

    Hi Chandoo, Can you look at this dashboard I created involving statistics from my favorite baseball team from last year. In the Batting Dash tab, I have a v look up and a slicer connected to the batting statistics tab. I want to add players to it. I know I have to use the offset function but...
  6. J

    Slicer connection to chart

    Hi All, On my batting dash tab I have a slicer where you can choose an individual player and get their stats. I also made that individual player's HR pivot table with a chart. I copied the chart to the batting dash but whenever I choose a player the chart doesn't correspond. Can you fix...
  7. J

    Pivot table chart

    Hi Chandoo Experts, I am working on this dashboard and would like to put in a chart. On sheet 4, I made a pivot table resembling the total number of home runs of each player by month. I would like to put in a line chart in batting dash tab. When I choose a player, I would like the chart to...
  8. J

    Vlookup queston

    Hi Chandoo I have a vlookup question for you. I made a dashboard of my favorite baseball team. I think it looks pretty cool. On the batting dash tab, there is a spot where I would like some stats regarding the players position, games, games started, and innings. The data reflecting that is...
  9. J

    Pivot Table

    Hi Chandoo People, Attached is the Detroit Dashboard you have probably seen before. On the Offense Dash tab, I would like to put a pivot table under the v lookup for each player. However I can't seem to get it when I choose a different player. I have the stats for two players Alex Avila and...
  10. J

    Dashboard Opinion

    Hi Chandoo, Can you ladies or gentlemen grade my dashboard for me? This was my first attempt at it and would like to get some feedback. If there is anything I can add or if you can improve on it visually, please feel free to make any changes you like. I appreciate your comments. Thank you...
  11. J

    Pic Formula

    Hi Ladies and Gentleman Not sure why the Index/Match formula isn't working on sheet 3 as it is on sheet 2. Can you check it out for me and tell me what I did wrong? Also, can I put in a diamond chart reflecting the position of the chosen player in sheets 2 and 3. Thank you as always. Joe.
  12. J

    Tiger Dashboard

    Hi Chandoo, I would like to make a dashboard involving my favorite sport team the Detroit Tigers. I've got all the statistics in place, including a v look up for pitchers (sheet 2), and for batters (sheet 3). I would like a pic on each player, I started it but got lost in the named range and...
  13. J

    pic

    Hi All, Thank you for your help on my previous questions. I was wondering if you could help me how to do the pic on this file. I want to apply the same to another project I am doing. If you could let me know how you did that =pic formula I would appreciate it. Thank you, Joe from Michigan.
  14. J

    Linking Worksheets

    Hi Chandoo Experts, I am working on this payroll chart and would like to know how to add a new employee and link his/her information to the other tabs. I thought I could use the offset function for this. Let me know what your thoughts are. Thanks, Joe.
  15. J

    Formulas for timesheet

    Hi Chandoo Experts, I was just wondering if you can check out my formulas for this time sheet. I think I got a little confused on them. Can you correct this for me? Thank you. Joe, Michigan.
  16. J

    Payroll Visualization

    Hello Chandoo Experts, I was just wondering if you can help me make my payroll chart be a little bit more appealing. I had a grade worksheet that you guys helped me out and now would like your assistance on this one. Don't know how you do it, but thanks for your help. Also, could you check to...
  17. J

    Picture in Chart

    Hi Chandoo Expert, Hui helped me out on my project here, but I can't seem to coordinate the picture with the name. Can you write down a step by step instruction on how to do that for me? Thank you. Joe, from Michigan.
  18. J

    Grade

    Hi Chandoo Expert, Just a few more questions on this project. Can you help me understand how I can add more names to the drop down list so it will correspond to the formulas, chart, and the other information that's on their. Also, can you help me to put more rows and columns so the formulas...
  19. J

    Final

    Hi Chandoo Experts, I did a grade chart for my sister. I was just wondering if you can help me to check if everything is all set regarding formulas. I changed the grade chart to the main page. Also can I add rows and columns to reflect the formulas. I would appreciate any help in finishing...
  20. J

    Power Pivot Ribbon

    Hi All, Somehow I got this PowerPivot ribbon on my Excel 2013. Is there a way to disable it? Thank you for you help. Steve from Iowa.
  21. J

    My Grade Template

    Hi Chandoo Experts, Asheem helped me out in my grade evaluation worksheet a great deal. I would like to learn one more thing to do on it. When I select a name from the drop down list can I put a conditional formatting rule to highlight that individual's name all the way to the "grade" column...
  22. J

    Dashboard

    Hi Chandoo Experts, I was wondering if you can take a look at this grade evaluation worksheet I was working on. What I would like to know is how to add a picture to the name of the student when I click on his/her name, highlight his/her name on the data table, and adding a chart to the name of...
  23. J

    Data Needed

    Hi Chandoo Expert I was just wondering if you can send me some data so I can practice in creating dashboards. I'm just an individual who has no access to business related information. I would appreciate it if you can help me out. Thank you. Joe from Michigan.
  24. J

    Data Table (What If Analysis)

    Hi Chandoo Expert, In using data tables, I just want to know if I can set up data tables for sports related information. I don't have an example, but maybe you can set something up for me. Just kind of tired of looking at data tables in terms of sales and other stuff. Just thought I would...
  25. J

    data table what if anaylis

    Hi Chandoo Experts, I was just getting familiar on the data table in the what if analysis. What I am interested in using the data table is for sports statistics. Can you set up a data table for that kind of situation? Can you provide an example? Thank you. Joe from Michigan.
Back
Top