Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Y Axis Scale with percentages (Line Graph) | Charts and Charting in Excel | |||
Help with Graph Axis | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Updating a graph with 2 y axis | Excel Discussion (Misc queries) | |||
2 axis bar graph | Excel Discussion (Misc queries) |