On my spreadsheet, I've got three columns (compass bearing from a smoke
stack, distance from the stack, and smoke concentrations downwind from our
stack). Can Excel create a 2-D (concentration value shown at distance and
bearing) or 3-D plot (this might look like a topo map on a circular base)
with this data? I can manually convert the locations to latitude and
longitude tediously, but I'd like to be able to paste new data in the table
each month and see the effects without having to calculate latitude and
longitude each month. I could not find a way to automate the bearing and
distance conversion from the stack point to latitude and longitude. ...or
find a 3-D chart function within Excel. Is this too much to ask???