R
R-P
Hello,
After swearing, cursing, throwing things in anger because the HELP-function
doesn't seem to cater to my questions, I found this item which *finally*
sheds some light on issues I have been having with Excel since the start:
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
And yes, there is a question coming:
How to I use a RADAR-plot ? I have the same issue: I cannot assign the
proper format to the 'X-axis' (the circumferenceline, not the 'Y-axis' line
that is the radiusline (hope you follow my drift...))
Why I need this:
I have solarpanels. I want to investigate the gain of tracking the sun with
them vs. a stationary setup.
I have data which tells me the sunangle&azimuth (summer, winter, 9.00 AM,
1.00 PM, etc.)
I now want to plot the angle and azimuth for the 4 days of seasonchanging
but my table runs from e.g. 23º to 320º, not from 0 to 360º, hence my
circumferenceline shows values from 23 to 320 degrees, not 0 to 360.
Is there a way around this? The above mentioned site suggests only using
X-Y-plots, but I'm sure there's a way to do this properly.
Don't hesitate to trash me politely, as I only ask for help when I'm already
frustrated, and this sometimes shows in the way I post questions (I'm
sorry...)
Kind regards, and thanks for any help you can give me!
R-P
After swearing, cursing, throwing things in anger because the HELP-function
doesn't seem to cater to my questions, I found this item which *finally*
sheds some light on issues I have been having with Excel since the start:
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
And yes, there is a question coming:
How to I use a RADAR-plot ? I have the same issue: I cannot assign the
proper format to the 'X-axis' (the circumferenceline, not the 'Y-axis' line
that is the radiusline (hope you follow my drift...))
Why I need this:
I have solarpanels. I want to investigate the gain of tracking the sun with
them vs. a stationary setup.
I have data which tells me the sunangle&azimuth (summer, winter, 9.00 AM,
1.00 PM, etc.)
I now want to plot the angle and azimuth for the 4 days of seasonchanging
but my table runs from e.g. 23º to 320º, not from 0 to 360º, hence my
circumferenceline shows values from 23 to 320 degrees, not 0 to 360.
Is there a way around this? The above mentioned site suggests only using
X-Y-plots, but I'm sure there's a way to do this properly.
Don't hesitate to trash me politely, as I only ask for help when I'm already
frustrated, and this sometimes shows in the way I post questions (I'm
sorry...)
Kind regards, and thanks for any help you can give me!
R-P