Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2019, 09:52 PM
JoemanNville JoemanNville is offline Putting appropriate name and postion on a baseball diagram Windows 10 Putting appropriate name and postion on a baseball diagram Office 2013
Novice
Putting appropriate name and postion on a baseball diagram
 
Join Date: Feb 2019
Posts: 11
JoemanNville is on a distinguished road
Default Putting appropriate name and postion on a baseball diagram

Hi MS Office Experts,



I am creating a baseball dashboard involving statistics from my hometown Detroit Tigers. I was wondering if you can take a look at the baseball diagram that I created in the "Batting Dash." What I would like to do is to select a player from the drop down list and have his name and the percentage of games to appear in that particular position on the diagram. On sheet two are the names and positions of where each player played. Thank for your help. The file is attached. Joe, Michigan.
Attached Files
File Type: xlsx DDashboard.xlsx (232.0 KB, 12 views)
Reply With Quote
  #2  
Old 03-10-2019, 06:42 AM
jeffreybrown jeffreybrown is offline Putting appropriate name and postion on a baseball diagram Windows Vista Putting appropriate name and postion on a baseball diagram Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

There are a few tutorial on the web you can use to follow to do this.

https://www.youtube.com/watch?v=wlW2UKml9CY
https://www.xelplus.com/excel-lookup-on-pictures/

As for the percentage of games, take a look at a Vlookup.

https://contextures.com/xlFunctions02.html
Reply With Quote
  #3  
Old 03-10-2019, 12:39 PM
JoemanNville JoemanNville is offline Putting appropriate name and postion on a baseball diagram Windows 10 Putting appropriate name and postion on a baseball diagram Office 2013
Novice
Putting appropriate name and postion on a baseball diagram
 
Join Date: Feb 2019
Posts: 11
JoemanNville is on a distinguished road
Default

Thank you, but that isn't exactly what I am looking for.
Reply With Quote
  #4  
Old 03-10-2019, 09:32 PM
xor xor is offline Putting appropriate name and postion on a baseball diagram Windows 10 Putting appropriate name and postion on a baseball diagram Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

You wrote:

I was wondering if you can take a look at the baseball diagram that I created in the "Batting Dash." ....

But there is no diagram on that sheet.

There are two names on Sheet2, Smoker and Alcantar, but I can't find any of them in the drop down list so it is rather difficult to help.

Maybe you should more carefully explain exactly what you are looking for.
Reply With Quote
  #5  
Old 03-11-2019, 04:37 AM
JoemanNville JoemanNville is offline Putting appropriate name and postion on a baseball diagram Windows 10 Putting appropriate name and postion on a baseball diagram Office 2013
Novice
Putting appropriate name and postion on a baseball diagram
 
Join Date: Feb 2019
Posts: 11
JoemanNville is on a distinguished road
Default

Hi Xor,
I must have downloaded the wrong file.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking a button postion so that it doesn't scroll with the worksheet Guzziguy Excel 1 03-14-2018 08:27 AM
Putting appropriate name and postion on a baseball diagram Organization Diagram Seftonbarn Word 2 08-15-2016 09:05 AM
Copying diagram from excel to power point or word changes name of series in the diagram DrNic Excel 0 02-18-2016 09:08 AM
Putting appropriate name and postion on a baseball diagram network diagram arrows ketanco Project 3 02-14-2013 10:46 AM
Putting appropriate name and postion on a baseball diagram Font - baseball team wnyku Office 1 12-21-2011 07:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft