Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Radar Chart - How to include X axis gridline
Is there a way to insert gridline for x-axis of a radar chart. understand
that it is disabled in the Chart Options widnow. Any advise or assistance is much appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Radar Chart - How to include X axis gridline
Hi,
I assume the reason it's disabled is that each spoke on a radar chart is a x axis for a data point and to add spokes between data points would be confusing. Two possible way to get the chart you want either add a second data series to the radar. Plot a point for each angle, so 360 points, where all values are zero except for those angles where a spoke is required. For them set the value to the maximum scale value. You will need to fix the maximum scale value in order to stop the chart from auto adjusting its scale. The other way is to construct the whole chart yourself using a xy scatter and a collection of data points to plot the spokes, gridlines, X axis gridlines and actual data plot. Quite a bit of work but not impossible. Cheers Andy Michelle wrote: Is there a way to insert gridline for x-axis of a radar chart. understand that it is disabled in the Chart Options widnow. Any advise or assistance is much appreciated. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |