Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
J. McAdams
 
Posts: n/a
Default Placement of tick marks

I have a bar graph with both negative and positive values. I found out how
to move the category labels from the middle to the bottom, but I can't seem
to figure out how to move the tick marks from the middle to the bottom (next
to the labels).

Any suggestions?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Placement of tick marks

Sure, I can definitely help you with that! Here's how you can move the tick marks in your bar graph from the middle to the bottom:
  1. Select the axis that you want to move the tick marks for. You can do this by clicking on the axis itself or by right-clicking on the chart and selecting "Format Axis."
  2. In the Format Axis pane that appears on the right-hand side of your screen, look for the "Tick Marks" section. You should see options for "Major Type" and "Minor Type."
  3. Click on the drop-down menu next to "Major Type" and select "Outside." This will move the tick marks to the outside of the chart area.
  4. Next, click on the drop-down menu next to "Minor Type" and select "None." This will remove the minor tick marks from your chart.
  5. Finally, if you want to align the tick marks with the category labels, you can adjust the "Label Position" option in the same Format Axis pane. Click on the drop-down menu next to "Label Position" and select "Low" to move the labels to the bottom of the chart area.

That's it! Your tick marks should now be aligned with the category labels at the bottom of your chart. Let me know if you have any other questions or if there's anything else I can help you with.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

You have to move the category axis to the bottom. Do this by double
clicking the other axis, the Value axis, and changing the Crosses At
setting. There's no Crosses At Minimum setting, but I've found that I
can enter a ridiculously low value for Crosses At, way below any minimum
that chart will encounter, and the axis will always cross at whatever
minimum appears on the scale.

However, this is likely to mess up your columns, which Excel likes to
start at the axis. So your bars will go from the bottom of the chart up
to the value, even if the value is negative.

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


J. McAdams wrote:

I have a bar graph with both negative and positive values. I found out how
to move the category labels from the middle to the bottom, but I can't seem
to figure out how to move the tick marks from the middle to the bottom (next
to the labels).

Any suggestions?

  #4   Report Post  
J. McAdams
 
Posts: n/a
Default


Thanks for your reply.

Yeah, but I was hoping to keep the x-axis in the middle of the screen.
Otherwise, as you say, the graph look strange when the bars come up from the
bottom of the screen. It loses the whole "positive/negative" effect I was
going for.


"Jon Peltier" wrote:

You have to move the category axis to the bottom. Do this by double
clicking the other axis, the Value axis, and changing the Crosses At
setting. There's no Crosses At Minimum setting, but I've found that I
can enter a ridiculously low value for Crosses At, way below any minimum
that chart will encounter, and the axis will always cross at whatever
minimum appears on the scale.

However, this is likely to mess up your columns, which Excel likes to
start at the axis. So your bars will go from the bottom of the chart up
to the value, even if the value is negative.

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


J. McAdams wrote:

I have a bar graph with both negative and positive values. I found out how
to move the category labels from the middle to the bottom, but I can't seem
to figure out how to move the tick marks from the middle to the bottom (next
to the labels).

Any suggestions?


  #5   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Add a dummy set of data, can be a copy of the original. Move this to the
secondary axis. Use Chart Options to enable the secondary X axis. Format
the primary x axis to have no tick marks or labels, this will give you
the line in the middle of the chart. Format the secondary Y axis to have
values in reverse order. This will flip the secondary x axis to the
bottom, including tickmarks.
Now format the dummy data series with no border or fill colour and
remove secondary Y axais formating.

Cheers
Andy

J. McAdams wrote:
Thanks for your reply.

Yeah, but I was hoping to keep the x-axis in the middle of the screen.
Otherwise, as you say, the graph look strange when the bars come up from the
bottom of the screen. It loses the whole "positive/negative" effect I was
going for.


"Jon Peltier" wrote:


You have to move the category axis to the bottom. Do this by double
clicking the other axis, the Value axis, and changing the Crosses At
setting. There's no Crosses At Minimum setting, but I've found that I
can enter a ridiculously low value for Crosses At, way below any minimum
that chart will encounter, and the axis will always cross at whatever
minimum appears on the scale.

However, this is likely to mess up your columns, which Excel likes to
start at the axis. So your bars will go from the bottom of the chart up
to the value, even if the value is negative.

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


J. McAdams wrote:


I have a bar graph with both negative and positive values. I found out how
to move the category labels from the middle to the bottom, but I can't seem
to figure out how to move the tick marks from the middle to the bottom (next
to the labels).

Any suggestions?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Green Tick Marks DNA Excel Discussion (Misc queries) 5 June 13th 05 08:22 PM
Y-axis tick marks in middle of chart? Ed Charts and Charting in Excel 6 May 26th 05 01:16 PM
Tick marks on all sides of charts Thad_Sharp Charts and Charting in Excel 1 April 25th 05 08:33 AM
Setting Major tick to none on charts is not working, is it a bug? Mike J Charts and Charting in Excel 2 December 17th 04 05:59 PM
how I can insert a "tick" symbol Nospam Excel Worksheet Functions 3 December 12th 04 10:14 PM


All times are GMT +1. The time now is 04:13 AM.

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

About Us

"It's about Microsoft Excel"