Does anyone know how to get the values I assign to the y axis scale remain
static. I don't want them to be automatically changed as excel does.

Thanks!

Julie

"Jule13" wrote in message
...
Does anyone know how to get the values I assign to the y axis scale remain
static. I don't want them to be automatically changed as excel does.

Format Axis/ Scale
Unitick the Auto from Min & Max
--
David Biddulph

Hi,

You need to uncheck the Auto checkboxes on the scale tab of the format
dialog. Double click the Y axis to display the format dialog.

You should find though that entering your own min/max values will
automatically remove the Auto tick.

Cheers
Andy

Jule13 wrote:
Does anyone know how to get the values I assign to the y axis scale remain
static. I don't want them to be automatically changed as excel does.

Thanks!

Julie

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

I did uncheck those but when I put in my own mins and max - it changes them
on the chart to it's own values based on the increments. When I try to
indicate I want no increments - it says I have to have at least 1 for those.
Here's what I am trying to do - I have a pay scale that ranges from like
45555 through 99902. I can set salaries anywhere in between those ranges.
What I want to do is show where each of the salaries fall in those ranges but
without any artificial ticks in between. Does that make sense? These
salaries are random and so they don't go on a logical 100, 500, 1000 scale...
:(

thanks for any advice you can provide! Julie

"David Biddulph" wrote:

"Jule13" wrote in message
...
Does anyone know how to get the values I assign to the y axis scale remain
static. I don't want them to be automatically changed as excel does.

Format Axis/ Scale
Unitick the Auto from Min & Max
--
David Biddulph

"Jule13" wrote in message
...

"David Biddulph" wrote:

"Jule13" wrote in message
...
Does anyone know how to get the values I assign to the y axis scale
remain
static. I don't want them to be automatically changed as excel does.

Format Axis/ Scale
Untick the Auto from Min & Max

I did uncheck those but when I put in my own mins and max - it changes them
on the chart to it's own values based on the increments. When I try to
indicate I want no increments - it says I have to have at least 1 for
those.
Here's what I am trying to do - I have a pay scale that ranges from like
45555 through 99902. I can set salaries anywhere in between those ranges.
What I want to do is show where each of the salaries fall in those ranges
but
without any artificial ticks in between. Does that make sense? These
salaries are random and so they don't go on a logical 100, 500, 1000
scale...
:(

thanks for any advice you can provide! Julie

If you set the major & minor units to 54347, then it won't put any extra
ticks between 45555 & 99902
--
David Biddulph

Here's how to make a custom chart axis scale:

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

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


"Jule13" wrote in message
...
I did uncheck those but when I put in my own mins and max - it changes them
on the chart to it's own values based on the increments. When I try to
indicate I want no increments - it says I have to have at least 1 for
those.
Here's what I am trying to do - I have a pay scale that ranges from like
45555 through 99902. I can set salaries anywhere in between those ranges.
What I want to do is show where each of the salaries fall in those ranges
but
without any artificial ticks in between. Does that make sense? These
salaries are random and so they don't go on a logical 100, 500, 1000
scale...
:(

thanks for any advice you can provide! Julie

"David Biddulph" wrote:

"Jule13" wrote in message
...
Does anyone know how to get the values I assign to the y axis scale
remain
static. I don't want them to be automatically changed as excel does.

Format Axis/ Scale
Unitick the Auto from Min & Max
--
David Biddulph