Excel chart plotting, depending on weightage

N

newexler

New Member
Joined
Apr 3, 2009
Messages
18
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Question
Problems Encountered When Generating VBA Excel Charts with 15-Minute Interval Data.
Replies
0
Views
159
dilshod_k
D
E
  • Question
VBA for Web Scraping help
Replies
0
Views
593
epactheactor
E
J
  • Solved
Excel Selenium VBA Run-time error '32'
Replies
5
Views
620
Js Smith
J
A
  • Question
Chart values are showing different
Replies
0
Views
229
Allwinv
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,054
Messages
6,122,897
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top