I copied the data you had in your previous post and tried to plot it using Excel 2007. 3D line charts are generated correctly if the temperatures are converted to TEXT instead of NUMBERS, i.e. use a single quotation mark " ' " before the number like in '10 instead of 10. Column charts and stacked column charts are also generated correctly.
I hope you have limited temperature values, otherwise scrollable charts would be required to show the chart. You can also use text entries for temperature like Ten instead of 10, eleven instead of 11 and so on. Hope that helps. In case I have not understood your problem correctly do let me know. I can also be reached at anand...@gmail.com Warm regards, Anand Kumar On Sep 27, 12:02 pm, startingexcel <reach...@gmail.com> wrote: > Thanks anand, > > Yes the numbers in the columns of the zones indicate the weight ( i > mean number of times) > the temperature range represented in the first column. > > This is an attempt to show a viewer a line graph of each zone against > the temperature. > All zones thus can be shown with shift in the x coordinates as i don't > need it. I can send the format if i can attach the document. > > Regards and Thanks in Advance > -- Anand > On Sep 26, 9:59 pm, anandydr <anand...@gmail.com> wrote: > > > 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
