LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default Y axis to cross at zero

I have line graph of sines of angles 0 deg to 360 deg. I need the X axis to
show X-axis corresponding to angles 0, 90, 27, 360. But if I set
tick-marks every 90, the labels read 1,91,181,271,361.

This is because the "Scale" dialogue has "Value (Y) axis crosses at
category number: 1". This cannot be set to zero; it must be in the range 1
to 39999. How can I set the X-axis to commence at zero?

What point am I missing here???

Thanks

Paddy


 
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
shift Y axis Terry Charts and Charting in Excel 7 June 25th 06 06:18 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
How do I make two y axis in bar graphs (i.e. cross hatching)?? ancientk Excel Discussion (Misc queries) 1 January 29th 06 08:53 PM
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM


All times are GMT +1. The time now is 04:01 PM.

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

About Us

"It's about Microsoft Excel"