create multiple graphs/plots from xlsx file with n columns
<p>I have a .xlsx file with several column (with some inter-dependencies). I'd like to plot multiple graphs on the same chart using a select number of the columns. The first column is Date (which will be my only X-variable) and the remainder columns of interests will be Y-values. There are 1000 rows of data in this file.
 <a href="https://i.stack.imgur.com/jtqGy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jtqGy.png" alt="enter image description here"></a></p>

<p>So ...  </p>

<p>X-axis ... "Date" column only<br>
Y-axis (multiple data) ... columns B, C, D, E, T, U, V only  </p>

<p><strong>Question:</strong><br>
How to:<br>
1) Read the file<br>
2) plot a line graph of the data, all on the same chart (X-axis = Date, Y-axis = columns B, C, D, E, T, U, V)<br>
3) Color code each line with some type of a legend  </p>

<p><strong>I've read this post and many more (not allowed to post more than 2 links??) ... none has been helpful. Most are too arbitrary:</strong><br>
<a href="https://stackoverflow.com/questions/4877357/how-to-plot-all-the-columns-of-a-data-frame-in-r">how to plot all the columns of a data frame in R</a></p>