OOAK Table Tennis Forum


A truly International Table Tennis Community for both Defensive and Offensive styles!
OOAK Forum Links About OOAK Table Tennis Forum OOAK Forum Memory
It is currently 22 Nov 2018, 04:10


Don't want to see any advertising? Become a member and login, and you'll never see an ad again!



All times are UTC + 9:30 hours




Post new topic Reply to topic  [ 14 posts ] 
Author Message
PostPosted: 18 Sep 2018, 13:02 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 32046
Location: Adelaide, AU
Has thanked: 1676 times
Been thanked: 1138 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
Does anyone know of software to make charts like the one below? Excel can plot the points, but I don't think it can put a name to each point.

Attachment:
BTY_Blade.JPG
BTY_Blade.JPG [ 133.82 KiB | Viewed 446 times ]

_________________
OOAK Table Tennis Shop | Re-Impact Blades | Butterfly Table Tennis bats
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Butterfly Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide


Top
 Profile  
 


PostPosted: 18 Sep 2018, 13:48 
Offline
Super User

Joined: 16 Sep 2012, 19:52
Posts: 298
Has thanked: 6 times
Been thanked: 65 times
Blade: OSP Ultimate II
FH: Xiom Ω VII Asia Max
BH: Xiom Ω VII Asia Max
Actually, you can create Scatter charts with labeled points in Excel. You can even use custom images for the markers.


Attachments:
Excel Scatter.PNG
Excel Scatter.PNG [ 34.41 KiB | Viewed 439 times ]
Top
 Profile  
 
PostPosted: 18 Sep 2018, 14:03 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 32046
Location: Adelaide, AU
Has thanked: 1676 times
Been thanked: 1138 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
Thanks GMan4911

I've got three columns of data though, being: Name, speed, control

I want to plot speed vs control, and each point labelled with the name.

I can't see how excel can do this, but perhaps it can?

_________________
OOAK Table Tennis Shop | Re-Impact Blades | Butterfly Table Tennis bats
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Butterfly Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide


Top
 Profile  
 
PostPosted: 18 Sep 2018, 15:37 
Offline
Goes to 11
Goes to 11
User avatar

Joined: 13 Jan 2014, 20:27
Posts: 7200
Has thanked: 2 times
Been thanked: 891 times
There's an add-in for Excel called XY Chart Labeler. I've used it, it works pretty well.

http://www.appspro.com/Utilities/ChartLabeler.htm

Iskandar


Top
 Profile  
 
PostPosted: 18 Sep 2018, 17:54 
Offline
CTRL_ALT_Loop
CTRL_ALT_Loop
User avatar

Joined: 28 Nov 2011, 08:20
Posts: 1406
Location: Egersund, Norway
Has thanked: 152 times
Been thanked: 154 times
I have grown to deeply resent the attempts MS Office applications do towards reading my mind. I prefer to have the options available for myself to adjust. This is one important reason why I frequently use OpenOffice/LibreOffice instead. (My employer dictates MS Office as the Office tool of choice, so whenever collaboration/sharing is part of the process, I have to use that.)

In OpenOffice Calc I can make something like the requested chart within minutes, without any plugins installed or other technicalities. The same settings are probably available in Excel too, but buried deep below the wizardry of Excel-ence.

That Excel addon probably does the job. If not, you can send me your data and I'll return my suggestion. Am at my day job right now, so I can't promise that I have the time available immediately. Give it an hour or two.


Top
 Profile  
 
PostPosted: 18 Sep 2018, 18:19 
Offline
Super User

Joined: 16 Sep 2012, 19:52
Posts: 298
Has thanked: 6 times
Been thanked: 65 times
Blade: OSP Ultimate II
FH: Xiom Ω VII Asia Max
BH: Xiom Ω VII Asia Max
Tutorial for Excel 2003, 2007, 2010



Tutorial for Excel 2013+



Top
 Profile  
 
PostPosted: 18 Sep 2018, 22:06 
Online
Dr. Chop-Blogger
Dr. Chop-Blogger
User avatar

Joined: 23 Oct 2013, 00:48
Posts: 1420
Location: Boston
Has thanked: 487 times
Been thanked: 328 times
Blade: Donic Defplay
FH: Palio AK47 Blue
BH: Grass Dtecs OX
R or Python are much better for interactive data analysis and plotting/visualization.

_________________
USATT: 1776| League: 1903


Top
 Profile  
 
PostPosted: 19 Sep 2018, 06:59 
Offline
Call me Shrek!
User avatar

Joined: 25 May 2011, 12:38
Posts: 973
Location: California, USA
Has thanked: 9 times
Been thanked: 76 times
Blade: Hallmark Ultra
FH: Tenergy 05 FX max
BH: Rakza 7 Soft max
Alex, you can try this...



Top
 Profile  
 
PostPosted: 19 Sep 2018, 13:41 
Offline
Goes to 11
Goes to 11
User avatar

Joined: 13 Jan 2014, 20:27
Posts: 7200
Has thanked: 2 times
Been thanked: 891 times
GMan4911 wrote:
Tutorial for Excel 2003, 2007, 2010



Tutorial for Excel 2013+



The first one makes use of a macro, kinda involved. If you have an earlier version of Excel get the XY Chart Labeler:

https://xy-chart-labeler.software.informer.com/7.1/

If you have Excel 2013+ the second tutorial shows a very easy way to add and manipulate data labels. You can even move them around and they'll have a little line that connects the data point to the label. Actually it might be worth checking to see if it isn't in the earlier versions, too.

I'm a big user/believer of/in Excel (and spreadsheets in general - I started with Lotus 123) - it's great for manipulating and displaying data without a bunch of programming. I tried briefly one of the open source spreadsheets (back when Sun was trying to get people to use their PC based SunOS) but it made a huge mess of the spreadsheets I already had. (Not to mention SunOS didn't have USB drive support, which was really embarrassing for the demonstrators..)

Iskandar


Top
 Profile  
 
PostPosted: 19 Sep 2018, 14:45 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 32046
Location: Adelaide, AU
Has thanked: 1676 times
Been thanked: 1138 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
Does anyone know of any other software that creates visual charts like this? Excell is great for manipulating data, but not the most flexible in displaying data IMO.

I've seen tons of 'info-graphics' or 'info-charts', like visme.co, but they tend to be most visual and not big on displaying things like scatter graphs with labels that I'm after.

_________________
OOAK Table Tennis Shop | Re-Impact Blades | Butterfly Table Tennis bats
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Butterfly Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide


Top
 Profile  
 
PostPosted: 19 Sep 2018, 18:08 
Offline
Goes to 11
Goes to 11
User avatar

Joined: 13 Jan 2014, 20:27
Posts: 7200
Has thanked: 2 times
Been thanked: 891 times
If you're talking about charts exactly like the one you put in the first post, Excel will do those just nice. Yeah, there may be other charting software that makes some types of graphs better than Excel but I already know Excel pretty well and haven't found a need for them myself.

Iskandar


Top
 Profile  
 
PostPosted: 25 Sep 2018, 09:20 
Offline
Super User

Joined: 07 Nov 2014, 13:26
Posts: 638
Location: Bogor, Indonesia
Has thanked: 2847 times
Been thanked: 86 times
Blade: Butterfly Defence Alpha
FH: Donic Slice 40 CD 1.5 mm
BH: LKTStrgr+KokBLuJap 1.1 mm
haggisv wrote:
Does anyone know of any other software that creates visual charts like this? Excell is great for manipulating data, but not the most flexible in displaying data IMO.

I've seen tons of 'info-graphics' or 'info-charts', like visme.co, but they tend to be most visual and not big on displaying things like scatter graphs with labels that I'm after.
Another vote for

R +
RStudio or RKward +
https://www.r-graph-gallery.com/ to find chart You are looking for.

٩(◕‿◕。)۶

Sent from my i5E using Tapatalk


Top
 Profile  
 
PostPosted: 26 Oct 2018, 04:20 
Offline
New Member
User avatar

Joined: 12 Sep 2018, 16:11
Posts: 27
Location: Oregon, USA
Has thanked: 13 times
Been thanked: 4 times
Blade: Yasaka Sweden Classic
FH: Mark V
BH: Mark V
BeGo wrote:
R +
RStudio or RKward +
https://www.r-graph-gallery.com/ to find chart You are looking for.


I would also like to vote for R. It's free, and there are a lot of resources online to learn it. I would say that there is a learning curve, however.


Top
 Profile  
 
PostPosted: 29 Oct 2018, 03:30 
Offline
Super User

Joined: 11 May 2013, 18:01
Posts: 582
Location: Podunk Pongville USA MALE
Has thanked: 1 time
Been thanked: 18 times
Blade: XVT Balsa Carbon 10mm all
FH: Xiom Sigma Pro 2 2.0
BH: Globe 979 OX
I think you can make it at Google - Sheets.

_________________
Panda Drive / 4H Xiom Sigma Pro 2 2.0 / BH Xiom Omega IV Elite Max / Play right-handed
XVT balsa carbon 10mm / 4H Xiom Sigma Pro 2 2.0 / BH Globe 979 Long Pips OX / Play Left-handed shakehand
Stiga Def Wood / 4H Xiom Sigma Pro 2 2.0 / BH GD CC LP OX .. Play Left-handed
Cpen SOS Wood / 4H 729 802-40 2.0 / BH GD Talon use righthanded shakehand grip
HARDBAT / Shakehand Hock 3 ply / Friendship Dr Evil OX .. Play Right-handed


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ] 




All times are UTC + 9:30 hours


Who is online

Users browsing this forum: Google [Bot] and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Copyright 2018 OOAK Table Tennis Forum. The information on this site cannot be reused without written permission.

Powered by phpBB® Forum Software © phpBB Group




Don't forget to 'LIKE' our forum on Facebook if you enjoy the content: