Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
myhounds
 
Posts: n/a
Default Need specific tick marks on Y axis

I am sure this is probably something really easy, but for the life of me I
can't seem to figure it out. I tick marks on the y axis from 0 to mark 260
and 420. The biggest that I would need is 600, but I must have the 260 and
420 marked. How do I do that? I tried to change the minor/major things, but
that didn't work out. I am trying to chart my peak flow readings for my
asthma, and the 420 and 260 designate the zone lines of how bad my asthma is.
Thanks in advance! ")
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can put "ticks" wherever you want following this procedu

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

You might also prefer this approach, to mark 260 and 420 across the
entire chart:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

myhounds wrote:

I am sure this is probably something really easy, but for the life of me I
can't seem to figure it out. I tick marks on the y axis from 0 to mark 260
and 420. The biggest that I would need is 600, but I must have the 260 and
420 marked. How do I do that? I tried to change the minor/major things, but
that didn't work out. I am trying to chart my peak flow readings for my
asthma, and the 420 and 260 designate the zone lines of how bad my asthma is.
Thanks in advance! ")

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
Varying axis scaling jeffnoll Charts and Charting in Excel 2 February 18th 05 02:02 AM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
Scatter chart x axis tick mark lables so Charts and Charting in Excel 2 December 2nd 04 05:06 AM


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