Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Michelle
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
change axis info on radar charts alfred Charts and Charting in Excel 1 January 11th 05 05:36 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 04:54 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 02:48 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"