#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Numbers?

Hi, I need to create a graph which has 1-5 as possible 'scores' on the Y axis
and the actual scores on the X axis. As the data I have only goes up to 2.75.
This was ferom a survey conducted where I work, with the max score being 5.
However, when I try and make a chart, it only goes up to 3 on the Y axis. Any
clues?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 96
Default Numbers?

Pull up the properties dialog box for the Value axis (Y axis) and go to the
Scale tab. Enter 0 in the Minimum box and 5 in the Maximum box. The check
boxes for both of these should become un-checked. Click Okay and you chart's
Y axis should now have a minimum value of 0 and a maximum value of 5.

Hope this helps.

Thanks,
Bill Horton

"DeeDeeB" wrote:

Hi, I need to create a graph which has 1-5 as possible 'scores' on the Y axis
and the actual scores on the X axis. As the data I have only goes up to 2.75.
This was ferom a survey conducted where I work, with the max score being 5.
However, when I try and make a chart, it only goes up to 3 on the Y axis. Any
clues?

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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Completely baffled on what should be simple Pat Hughes Excel Discussion (Misc queries) 12 October 23rd 06 08:24 PM
conditional formatting Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM
How to generate sets of random numbers without having duplicates William Excel Worksheet Functions 1 June 6th 06 05:30 AM
Why are 1/2 my numbers imported as text and the rest as numbers? KBear Excel Discussion (Misc queries) 2 April 21st 06 01:40 PM


All times are GMT +1. The time now is 02:35 AM.

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"