Click here to Skip to main content
14,575,900 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
AnswerRe: Suggestions for graphing software... Pin
S Houghtelin2-Jul-18 1:24
professionalS Houghtelin2-Jul-18 1:24 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B2-Jul-18 2:39
MemberChris C-B2-Jul-18 2:39 
GeneralRe: Suggestions for graphing software... Pin
S Houghtelin2-Jul-18 2:51
professionalS Houghtelin2-Jul-18 2:51 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B2-Jul-18 3:10
MemberChris C-B2-Jul-18 3:10 
GeneralRe: Suggestions for graphing software... Pin
S Houghtelin2-Jul-18 3:12
professionalS Houghtelin2-Jul-18 3:12 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B2-Jul-18 3:29
MemberChris C-B2-Jul-18 3:29 
GeneralRe: Suggestions for graphing software... Pin
S Houghtelin2-Jul-18 3:33
professionalS Houghtelin2-Jul-18 3:33 
GeneralRe: Suggestions for graphing software... Pin
S Houghtelin3-Jul-18 2:37
professionalS Houghtelin3-Jul-18 2:37 
So, how was the salmon? Wink | ;)

Anyway I got 'yer Codez. It's like 6 lines of code.
# Install & Load Library
if (!require("readxl")) install.packages("readxl")
library("readxl")

# Choose & Read Excel file, the 2 denotes the desired sheet number.
my_data <- read_excel(file.choose(), 2)

# Extract data from the desired columns. RStudio will provide drop-down with column names.
Ydata <- my_data$Column_With_Ydata
Xdata <- my_data$Column_With_Xdata

# Plot data
plot(Ydata, Xdata)

As with any code you can get as fancy as you want, but for a one time look see...
It was broke, so I fixed it.

GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 19:18
MemberChris C-B3-Jul-18 19:18 
AnswerRe: Suggestions for graphing software... Pin
Foothill2-Jul-18 3:13
professionalFoothill2-Jul-18 3:13 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 18:52
MemberChris C-B3-Jul-18 18:52 
AnswerRe: Suggestions for graphing software... Pin
Kirill Illenseer2-Jul-18 21:39
MemberKirill Illenseer2-Jul-18 21:39 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 18:52
MemberChris C-B3-Jul-18 18:52 
AnswerRe: Suggestions for graphing software... Pin
Member 99910752-Jul-18 21:53
MemberMember 99910752-Jul-18 21:53 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 18:54
MemberChris C-B3-Jul-18 18:54 
AnswerRe: Suggestions for graphing software... Pin
Pete Kelley3-Jul-18 2:17
MemberPete Kelley3-Jul-18 2:17 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 18:58
MemberChris C-B3-Jul-18 18:58 
AnswerRe: Suggestions for graphing software... Pin
mngerhold3-Jul-18 3:10
Membermngerhold3-Jul-18 3:10 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 19:00
MemberChris C-B3-Jul-18 19:00 
GeneralRe: Suggestions for graphing software... Pin
mngerhold3-Jul-18 21:01
Membermngerhold3-Jul-18 21:01 
AnswerRe: Suggestions for graphing software... Pin
cmkrnl3-Jul-18 4:21
Membercmkrnl3-Jul-18 4:21 
AnswerRe: Suggestions for graphing software... Pin
jcmaida3-Jul-18 5:35
Memberjcmaida3-Jul-18 5:35 
GeneralRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 19:03
MemberChris C-B3-Jul-18 19:03 
AnswerRe: Suggestions for graphing software... Pin
Chris C-B3-Jul-18 19:24
MemberChris C-B3-Jul-18 19:24 
GeneralCCC Pin
pkfox1-Jul-18 21:46
professionalpkfox1-Jul-18 21:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.