Offsetting x axis chart labels

  • Thread starter Thread starter zoews
  • Start date Start date
Z

zoews

Please help - I'm really stuck with an approaching deadline...

I'm doing a column chart with negative and positive bars, with the
axis crossing at 0. My x axis labels need to be far enough down fro
the columns so that they don't overlap the negative ones, but th
offset feature only goes up to 1000 and this isn't enough. I've trie
hardcoding spaces into the source cells for the labels to offset the
further but although it works fine on screen and aligns the tex
perfectly, in print preview and when actually printing the labels don'
stay put.

Any help gratefully appreciated!

zo
 
Hi Zoe,

Select the X axis and press CTRL+1 in order to display the format
dialog. On the Patterns tab you can set the Tick Mark Labels to Low.
Please help - I'm really stuck with an approaching deadline...

I'm doing a column chart with negative and positive bars, with the x
axis crossing at 0. My x axis labels need to be far enough down from
the columns so that they don't overlap the negative ones, but the
offset feature only goes up to 1000 and this isn't enough. I've tried
hardcoding spaces into the source cells for the labels to offset them
further but although it works fine on screen and aligns the text
perfectly, in print preview and when actually printing the labels don't
stay put.

Any help gratefully appreciated!

zoe


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top