Plotting data R : <p>I have a simple tasks I would like to do. Using an RODBC connection I have connected R to a SQL server database. There are four tables in the database and they are tenors of Libor rates</p>

<pre><code>Libor_1_mos
Libor_3_mos
Libor_6_mos
Libor_12_mos
</code></pre>

<p>Each table has two columns. The first column shows dates and the second column shows rates. </p>

<p>I would like a simple chart that plots the rates based on the dates in column 1. Straightforward - that is all that needs to be done. The x-axis should be dates (column 1) and the y axis should be rates (column 2). Note it is 5 years worth of data so showing every possible date on the x-axis may not be feasible. </p>

<p>Here is my work so far I am using the Libor_3_mos as an example</p>

<pre><code>threemosdata &lt;- sqlQuery(con,"select * from Libor_3_mos)
</code></pre>

<p>Using that line I can read the data from the table. So for instance </p>

<pre><code>colnames(threemosdata)
</code></pre>

<p>will give me the names of the column in the table.</p>
