I have an Excel question. If you want to start a graph at zero (Y scale) and have the next number skip to say 1,000 and then have the Y scale increment 1,000 on each hatch mark after that to say 10,000, does anyone know how to acccomplish this in Excel? I'm not sure what the terminology is--double hatch marks? I know how to start a graph at other than 0.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Question
- Thread starter joanmp
- Start date
I hope this is what you are asking.
Once you have plotted the Chart, you can point to the Y axis, Right click and choose Format axis. Under the scale tab set Minimum to Zero, maximum to whatever your Max is and Major Unit to 1000 and Minor unit to (say 200).
Once you have plotted the Chart, you can point to the Y axis, Right click and choose Format axis. Under the scale tab set Minimum to Zero, maximum to whatever your Max is and Major Unit to 1000 and Minor unit to (say 200).
- Thread starter
- #3
No not possible to send attachments. If you want a sample you would have post your e-mail address.
- Thread starter
- #5
- Status