Where's the weight assigned to each region? Do the numbers below north, south, east and west represent that? In that case what does this table shows?
On Sep 25, 4:31 am, startingexcel <reach...@gmail.com> wrote: > Excel chart plotting, depending on weightage > 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 particular temperatures are hit. > Graph showing Temperatures of various regions, the number indicate the > recorded number of Temperatures > Temperature East West North South > > 10 5 6 23 12 > 11 8 3 3 23 > 12 10 6 0 34 > 13 12 2 2 12 > 14 15 2 9 8 > 15 19 3 2 4 > 16 22 34 3 6 > 17 1 0 2 2 > 18 0 34 35 6 > 19 0 3 2 2 > 20 0 0 4 5 > 21 23 0 4 2 > 22 23 0 2 0 > > 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. > > Thanks a lot in Advance. > L -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
