Y axis increments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

syssupspe - 11 Sep 2007 23:28 GMT

Hi,
I have a column chart
On my Y axis I have -
0,2,4,6,8,
I would like it to read -
0,2,3,5,6,8
And also with the % sign behind the number.
Also-how do I get less or more space between my groups of columns(there are
4 columns in one group and 3 groups).
Also- Is there a way to get more space between the Y axis and my first group
of columns on my X axis?
Thanks

Reply to this Message

Del Cotter - 12 Sep 2007 11:56 GMT

>I have a column chart On my Y axis I have - 0,2,4,6,8,
>I would like it to read - 0,2,3,5,6,8

You will need to make a specially-constructed axis of your own design to
replace the Excel one. Try one of these tutorials:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://www.tushar-mehta.com/excel/newsgroups/flexible_log_scale/

>And also with the % sign behind the number.

Format the axis labels with a custom number format "General%". You can
find "Custom" at the bottom of the list of formats in Format Axis..
Number..

>Also-how do I get less or more space between my groups of columns(there are
>4 columns in one group and 3 groups).

Click on a column and select "Format Selected Object.. Options.."

>Also- Is there a way to get more space between the Y axis and my first group
>of columns on my X axis?

Make a dummy row in your data table with no data in it. That will make a
gap to keep the first group of columns away. Alternatively, you might be
able to move the custom Y-axis that you made inthe first question.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message