Hi, Im not new to Excel (2002) but my knowledge level only scratches the surface. Ive just learned how to do the basics in charts and using a data table. From what I understand so far, I can put numbers into the data table and the chart will update. That wasnt hard to figure out. Can I achieve the same result by entering text instead of numbers? Perhaps the best way to ask my question is to give an example, but first, my objective is:
I want to plot the events of a scenario on a daily basis. Ive got 31 days of a month along the horizontal axis (category axis). The various aspects are represented by the value axis or vertical axis, also represented in the Legend.. Each aspect has anything up to around 10 variables, and reflects that on the chart by entering a number Ive allocated to that variable. Unless youve got an elephants memory its a very un-elegant method I suspect.
Example: Suppose I want to plot the rainfall where I live on a daily basis for a month . Each day is represented along the horizontal axis by 31 cells. So, for each day I can simply punch in the amount of mls where applicable and the chart shows the right amount. However, what if I want to include, say, wind direction as well? 1/North (NTH) - 2/Nor Nor west (NNW)- 3/North west (NW) - 4/ West (W) - 5/ South west (SW) - 6/South South west (SSW) - 7/ South (S) - 8/South South East (SSE) - 9/South East (SE) - 10/ East (E)- 11/North East (NE) - 12/ North North East (NNE). .... Rather than having to try and remember the right number allocated as in the preceding example, and punch that in, it would make more sense to just enter NW or E and so on. Is there a way to do this thats not too complicated? or, could someone guide me thru the necessary steps? I hope my question makes sense.
Any help much appreciated.
Musical
Bookmarks