Hi Experts, I have created a bit map after failing to get the pattern, I am not sure how to attach a document here, if anyone wants to help me, please send me a note, i will send them example of what i am trying to achieve. in short
I want all the columns to be displayed in graph based on the weightage, line graph spread over the x co-ordinates. as i am sure what's important is the temperature and number of times it hit them in different zones.. Number of hits on the x axis makes the graph plague, spread over and not really readable. So i would like a line graph of each zone with markers size proportional to the Y axis hit number and other zones represented with some space spread on the x axis .. Interestingly i am told that graph is x and y co-ordinates only. Cannot we assume some x axis range for each of this zones to get the representation i am looking for. Regards and Thanks in Advance On Sep 25, 11: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
