Offsetting x axis chart labels

[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

 

[Andy Pope]

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

--

Cheers
Andy

http://www.andypope.info

 

[zoews]

durrrrrrr

guess i should have seen that, but many thanks for your prompt
response!