(Msg. 9) Posted: Wed Nov 11, 2009 9:31 am
Post subject: Have the same issue [Login to view extended thread Info.] Archived from groups: microsoft>public>excel>charting (more info?)
Lori - I have the same need that you described. Were you able to get your problem figured out? If so, would you mind sharing your workbook?
Much thanks!
WalterKiw wrote:
Hi Lori,it worked, but it's a bit frustrating - really trying to plot 12 h of
18-Mar-08
Hi Lori,
it worked, but it's a bit frustrating - really trying to plot 12 h of data,
but lots of hours the wind comes from the same direction and changing "series
1" to the appropriate time is no fun. May end up filing this in the "too
hard basket" for the benefit derived.
Cheers,
Walter
"Lori" wrote:
Previous Posts In This Thread:
On Sunday, March 16, 2008 8:38 PM
WalterKiw wrote:
Plotting wind speed and direction on a compass?
Hi, I have wind velocity (m/s) and direction (degrees) from a weather station
and want to plot it with the direction plotted around a 360 degree circle
(compass?) with the wind represented by an arrow pointing at the appriate
direction, and it's force by the length of the arrow. Sample data might be
Direction velocity
340 2.1
310 5.2
(and there's date and time data also) Any way to do this? It's hourly data
for 4 distinct weeks of the year (2 Sept, 2 Nov) for a 5 year period.
Rgds.
Walter
On Monday, March 17, 2008 12:14 PM
Lor wrote:
Try an XY chart with straight lines between points. Here's a start...
Try an XY chart with straight lines between points. Here's a start...
Choose Insert > Names > Define:
On Monday, March 17, 2008 4:44 PM
WalterKiw wrote:
Thanks LoriTrying to do this with excel07, and not having a lot of success.
Thanks Lori
Trying to do this with excel07, and not having a lot of success. Defined
direction and velocity, defined x and y. selected the series, went to formula
bar to change =series((etc)) and it sits there laughing at me. (well, it does
nothing)
Any hints for Office 2007 sufferers?
Walter
"Lori" wrote:
On Monday, March 17, 2008 9:46 PM
Lor wrote:
I don't have any experience with office 2007 i'm afraid.
I don't have any experience with office 2007 i'm afraid. I would suggest
first creating a scatter using direction and velocity for the x and y values,
then change the source data to refer to "sheet!x" and "sheet!y" where "sheet"
is the sheet name.
Insert extra lines inside the data range and the chart lines should update,
you need to update the labels manually though.
On Tuesday, March 18, 2008 7:26 PM
WalterKiw wrote:
Hi Lori,Thanks - this is the type of plot I'm after - Will have a go and see
Hi Lori,
Thanks - this is the type of plot I am after - Will have a go and see what
happens.. Will let you know.
W
"Lori" wrote:
On Tuesday, March 18, 2008 11:55 PM
WalterKiw wrote:
Hi Lori,it worked, but it's a bit frustrating - really trying to plot 12 h of
Hi Lori,
it worked, but it's a bit frustrating - really trying to plot 12 h of data,
but lots of hours the wind comes from the same direction and changing "series
1" to the appropriate time is no fun. May end up filing this in the "too
hard basket" for the benefit derived.
Cheers,
Walter
"Lori" wrote:
On Wednesday, March 19, 2008 4:34 AM
Andy Pope wrote:
Re: Plotting wind speed and direction on a compass?
Hi,
Do you know of any sites that have examples of the chart look you are after?
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"WalterKiwi" <WalterKiwi DeleteThis @discussions.microsoft.com> wrote in message
news:0F7E9725-E20A-4654-BE28-D91DB7FE395A@microsoft.com...
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office