Search results

Here is the final copy. Choose a player from the slicer and notice how it changes positions. J.D Martinez and Nick Castellanos however has NA's. Not sure why. But for the most part it's working. Appreciate you taking your time to figure that out for me.

Cool Hui that did the trick. Thanks so much.

I've plotted the players position on the (positions tab) where you told me to. So if you click the players names from the slicer it stays the same. Does it have to do something with the formula in S-7? I can change the players positions in q-7 and r-7. I appreciate your help.

Hey, I figured it out and plotted all the x/y according to the postions. Except when I hit the player from the slicer it's not moving the players name to the right position. All of them are at the last position where I entered in the x/y plot.

I think I figured it out, although I am just guessing at the x/y figures until it pops up in the right place.

Hui, One more thing. I noticed that some of the players aren't coming up on their respective positions. How do I read the x y layout? For example Miguel Cabera should be closer to the third base area. How can I adjust that?

Hi Hui, Thanks for pointing that out for me. That's exactly how i wanted it to look like. I am just at awe at your expertise on excel.

Hi Hui, Thanks for responding, but that is a little bit out of my relm there. Not sure how to do that.

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

Oh ok I see, I added austin jackson in the oppenent batting stats and it did pop up. Thanks.

Hi Naray, Thanks for looking at it again. It is on the batting stats tab. Also, can I put a diagram of a baseball field and show each position where the players played?

Hi Narayan, Yes I did. If you have the time please look at the file. It is under the batting dash tab. The blank is the last item. It is connected to the batting stats tab. The name should be Austin Jackson. I might want to ask you another question on this project. Thanks.

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.

Hey Luke, Thanks again for your assistance. That's what I wanted. Pretty funny how you replied to me again. Many thanks. Joe.

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

Hi Luke, Yes thank you very much for your help on this. I couldn't quite figure out why that wasn't working like the pitching dashboard was. It's been awhile since I looked at. Is there any other suggestions that you can think of on how I can improve on it? Spruce it up a bit and adding any...

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

I think I am going to start from scratch. Thanks for your help.

How did you connect it?

Thank you, now only if I can figure out how to connect the "Choose A Player" Slicer to the graph.

Hi Somendra, Yes, that's what I wanted. Can you explain how you did that for me? Thank you.

Hi Somendra, What I mean is if you take a look at the player in the v look up its not corresponding to the players I added to the Batting Statistics table. I added Tyler Collins and Yoenis Cespedes to that table. Thanks for looking.

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

Hui, can you take a look at it one more time? The chart doesn't seem to be changing when I choose the player. Only the name does not thstats. Thanks.

thank you hui!