Thread: changing axes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default changing axes

Chart type?

Generally you have little control over non-uniform display of axis tick
labels. But you can sometimes get what you want with custom number formats.
For the Y axis, you could use a format like

[=10]"";General

For the horizontal axis, you have to start the axis at 0 March (i.e., 29
Feb) and suppress the first label, through perhaps a format like

[<39508]"",mmm d

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


"Damian" wrote in message
...

I currently have categories going from 1st of may to 11th may. How do I
get
it to just have labels for the even numbers (2nd/4th/6th/8th/10th)?

Also, how do I have 10,20, 30, 40 amd 50 on the value axis. How do I
remove
the bottom one (10) but keep the rest?