On the plot you may wish to set the final points line style to None in order to The legend and format the secondary axis as requried. Secondary axis category labels to the range E2:E9 The dummy data series to the secondary axis.Ĭan set the Line pattern to None on the dummy series to make in invisible. In the Example workbookis a sheet containing data in order to build the following example.Īll the lines by formatting the axis and setting the Line to None.Ĭonstruct the angle axis use a dummy data series. The plot can be altered by charting either a zero or a #N/A. For angles that are not contained within the data table the effect of Which points are plotted is determined byįunction. The angle and distance data is stored in a table with a named range. Requires 2 data series in order to generate the spiral effect. The polar plot is created using the Radar chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |