Anyone know how to do this in Excel?

[FunkyT]

http://img61.imageshack.us/img61/466/excel7no.jpg

[Bob Phillips]

I am sure loads of people do, but if you are not going to be more explicit
than that I cannot see them bothering.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"FunkyT" <[email protected]> wrote in
message news:[email protected]...
>
> http://img61.imageshack.us/img61/466/excel7no.jpg
>
>
> --
> FunkyT
> ------------------------------------------------------------------------
> FunkyT's Profile:
http://www.excelforum.com/member.php...fo&userid=6993
> View this thread: http://www.excelforum.com/showthread...hreadid=482194
>

[FunkyT]

What further information is required? I want to display a +ve value both above the below the x axis.

[Bill Sharpe]

FunkyT wrote:
> What further information is required? I want to display a +ve value
> both above the bellow the x axis.
>
>
Short answer to short question:
You need to customize a chart to do what you want.

Bill

[FunkyT]

Thanks - do you know how I need to customize it? Thanks.

[Bill Sharpe]

FunkyT wrote:
> Thanks - do you know how I need to customize it? Thanks.
>
>
A Google search for "Excel chart customination" yields lots of
possibilities.

Bill

[MrShorty]

What further information is required? I want to display a +ve value both above the below the x axis.

Assuming the values below 0 on the y axis are negative values that you don't want the '-' sign to display, you could use a number format code of 0;0;0 on the y axis.

[FunkyT]

Thanks very much. That's a great help.