How do I justify/align tick mark labels on a horizontal bar chart?

B

blinko

I'm doing a bar graph of survey question responses; the questions are long so
they word-wrap, but they seem to be "center" aligned so the formatting looks
bad. Can I left or right-justify them?
 
J

Jon Peltier

Yet another property of axis labels that Excel will not trust us with.

Some people would hide the default axis labels (double click the axis,
find the appropriate "None" on the Patterns tab) and replace them with
textboxes. Easiest way to add a textbox that's linked to a cell? Select
the chart, type an equals sign, then click on the cell. Now format and
position it.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I right justify the text labels in a chart? 2
Problem building horizontal bar chart paired bars, centered on zer 2
How to justify categories in a chart 1
Text-wrapping horizontal axis labels 4
bar chart prints 1 unwanted horizontal row of dots & tick marks? 0
Align x axis labels at 45 degrees using vba, please help! 0
Tick Mark Label 2
x axis tick mark labels 1

Top