How2 Draw chart in Excel 2007

[sukkaa]

Dear Mr. Excel Members,

I am trying to create a graph where I show how a websites traffic patterns have changed over 4 months, but I cannot create a chart/graph which will show the change in traffic sources (example, SEM). Thank you

Here is the table:

<table border="0" cellpadding="0" cellspacing="0" width="435"><col style="width: 107pt;" width="142"> <col style="width: 57pt;" width="76"> <col style="width: 63pt;" width="84"> <col style="width: 42pt;" width="56"> <col style="width: 58pt;" width="77"> <tbody><tr style="height: 24pt;" height="32"> <td style="height: 24pt; width: 107pt;" height="32" width="142">
</td> <td class="xl66" style="width: 57pt;" width="76">Oct</td> <td class="xl66" style="width: 63pt;" width="84">Nov</td> <td class="xl66" style="width: 42pt;" width="56">Dec</td> <td class="xl66" style="width: 58pt;" width="77">Jan</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Direct/Bookmark</td> <td class="xl63">48%</td> <td class="xl63">46%</td> <td class="xl63">29%</td> <td class="xl63">24%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">SEM</td> <td class="xl65">30%</td> <td class="xl65">36%</td> <td class="xl65">45%</td> <td class="xl65">41%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Smartphone</td> <td class="xl63">8%</td> <td class="xl63">2%</td> <td class="xl63">12%</td> <td class="xl63">8%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">Social Media</td> <td class="xl65">5%</td> <td class="xl65">2%</td> <td class="xl65">12%</td> <td class="xl65"> </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">SEO</td> <td class="xl63">8%</td> <td class="xl63">9%</td> <td class="xl63">1%</td> <td class="xl63">8%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">Other</td> <td class="xl65">2%</td> <td class="xl65">4%</td> <td class="xl65">2%</td> <td class="xl65">1%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Display</td> <td>
</td> <td>
</td> <td>
</td> <td class="xl63">18%</td> </tr> </tbody></table>

 

[Andrew Poulsom]

Welcome to the Board.

Select your data, click the Insert tab, click Column then click the example at top left.