#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 516
Default Value axis help

Hi, i have done a line graph and all my date have values say 2 - 3 so lots of
date say 2.13, 2.45 and there are 12 lots of data etc etc, i have produced my
graph and the value axis reads 0 0.5 1 1.5 2 2.5 3 3.5, is there anyway i can
get it to read from 2 - 3 so everything fits on as i have 12 lots of data and
everything is squashed on at the top..? Hope that makes sense?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 516
Default Value axis help

to add some more info, i have 12 different lines on my graph and its very
cramped, i changed the value of the value axis but its still cramped as a lot
of the data are similar values so its a multitude of colours and
confusing.... any suggestions? Also is there anyway of hiding data on the
graphs or anyway of bringing up just one of the 12 different lines by say
clicking the name of the data on the legend, anything like that possible?

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
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


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