![]() |
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 |
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. |
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