Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-09-2019, 09:52 PM
JoemanNville JoemanNville is offline Windows 10 Office 2013
Novice
 
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, 6 views)
Reply With Quote
  #2  
Old 03-10-2019, 06:42 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 526
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
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 Windows 10 Office 2013
Novice
 
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 Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,019
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
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 Windows 10 Office 2013
Novice
 
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
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
network diagram arrows ketanco Project 3 02-14-2013 10:46 AM
Font - baseball team wnyku Office 1 12-21-2011 07:31 PM


All times are GMT -7. The time now is 08:29 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft