ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Assigning X-axis to graph (https://www.excelbanter.com/excel-worksheet-functions/126275-assigning-x-axis-graph.html)

R-P

Assigning X-axis to graph
 
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/ChartsH...ValueAxis.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

R-P

Assigning X-axis to graph
 
Sorry for not posting this in the charting section... If there's an ADMIN:
you're very welcome to still do so.

R-P

Assigning X-axis to graph
 
And since I have now found the chartingsection, my search resultet in a lot
more hits. I have plent of reading now...

Discard these three posts...

"R-P" wrote:

Sorry for not posting this in the charting section... If there's an ADMIN:
you're very welcome to still do so.



All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com