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
