Excel chart plotting, depending on weightage

[newexler]

Hi experts,

Need help in ideas and plotting a graph to show a weightage of temperatures hit in 4 zones. I cannot relate this to x axis, i want to represent all in one chart so that i present a viewer, the number of times a particualar temperatures are hit.


<table width="692" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="3"> <col style="width: 86pt;" width="114"> <col style="width: 50pt;" width="66"> <col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 12.75pt;" height="17"> <td colspan="10" class="xl26" style="height: 12.75pt; width: 520pt;" width="692" height="17">Graph showing Temperatures of various regions, the number indicate the recorded number of Temperatures</td> </tr> <tr style="height: 12pt;" height="16"> <td style="height: 12pt;" height="16">
</td> <td>
</td> <td>
</td> <td class="xl25">Temperature</td> <td class="xl25">East </td> <td class="xl25">West</td> <td class="xl25">North</td> <td class="xl25">South</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td class="xl24">
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">10</td> <td class="xl24">5</td> <td class="xl24">6</td> <td class="xl24">23</td> <td class="xl24">12</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">11</td> <td class="xl24">8</td> <td class="xl24">3</td> <td class="xl24">3</td> <td class="xl24">23</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">12</td> <td class="xl24">10</td> <td class="xl24">6</td> <td class="xl24">0</td> <td class="xl24">34</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">13</td> <td class="xl24">12</td> <td class="xl24">2</td> <td class="xl24">2</td> <td class="xl24">12</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">14</td> <td class="xl24">15</td> <td class="xl24">2</td> <td class="xl24">9</td> <td class="xl24">8</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">15</td> <td class="xl24">19</td> <td class="xl24">3</td> <td class="xl24">2</td> <td class="xl24">4</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">16</td> <td class="xl24">22</td> <td class="xl24">34</td> <td class="xl24">3</td> <td class="xl24">6</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">17</td> <td class="xl24">1</td> <td class="xl24">0</td> <td class="xl24">2</td> <td class="xl24">2</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">18</td> <td class="xl24">0</td> <td class="xl24">34</td> <td class="xl24">35</td> <td class="xl24">6</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">19</td> <td class="xl24">0</td> <td class="xl24">3</td> <td class="xl24">2</td> <td class="xl24">2</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">20</td> <td class="xl24">0</td> <td class="xl24">0</td> <td class="xl24">4</td> <td class="xl24">5</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">21</td> <td class="xl24">23</td> <td class="xl24">0</td> <td class="xl24">4</td> <td class="xl24">2</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl24">22</td> <td class="xl24">23</td> <td class="xl24">0</td> <td class="xl24">2</td> <td class="xl24">0</td> <td>
</td> <td>
</td> </tr> </tbody></table>Note:Here over a period of time, samples are collected across various regions and I would like to represent this way
Y axis: Temperature and I do not see anything wrt to x axis or I leave to the experts.
Looking to clearly show 4 graphs in a single chart which shows a pattern of temperatures. The more the hits on a particualar temperatures, the bold is the marker ( diamond, or whatever).
I am thinking if the 4 regions (east, west, north, south) are plotted at different x co ordinates so that viewer could co-relate with the temperatures on the Y axis.

 

[gardnertoo]

I think you actually want a graph known as a histogram, where the X axis is temperature and the Y axis is the count.