Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Novice trying to sort the values on a radar graph

Hi, I need the values on a radar grapgh to show as 0, 3, 6, and 9 as
the outside of the 'web'. However the values in my data only go up to
5, how can I make the graph show up to 9 and only show the 3 radiating
lines I want i.e. 3, 6, & 9?
really new to this, so feel free to treat like an idiot!

  #2   Report Post  
pdberger
 
Posts: n/a
Default Novice trying to sort the values on a radar graph

Good question. Here's what you do:

* Slide the cursor over the rib of the radar graph until you see a little
box open up saying "format axis".
* Right-click on the axis.
* A little dialog box opens up, and you should click the 'format axis'
option.
* A bigger dialog box opens up, and you should click on the 'scale' tab.
You can then set the maximum number on the axis to '9' or any other number
you want.

hth.

" wrote:

Hi, I need the values on a radar grapgh to show as 0, 3, 6, and 9 as
the outside of the 'web'. However the values in my data only go up to
5, how can I make the graph show up to 9 and only show the 3 radiating
lines I want i.e. 3, 6, & 9?
really new to this, so feel free to treat like an idiot!


  #3   Report Post  
 
Posts: n/a
Default Novice trying to sort the values on a radar graph

Thanks for your time - that sorted it.

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
How to specify values for X axis in a Graph Pankaj Charts and Charting in Excel 1 September 27th 05 05:06 PM
how do i find values on a line graph in Excel? sorrelponie Excel Discussion (Misc queries) 1 September 20th 05 07:35 PM
ignore missing values while ploting graph Excel plot Excel Discussion (Misc queries) 2 September 15th 05 06:48 PM
"-" ignored in sort Mike H Excel Discussion (Misc queries) 8 January 2nd 05 07:48 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 09:52 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"