How to display the negative bar in bar chart?
 

Hello,

I have created one bar chart. but it could not accept negative
values. my x axis range is -150, -100, -50, 0, 50, 100. For example
one of the SeriesCollection(1) value is -75.Bar width is 100. I want to
print the bar from -75 to 75.(Starting position(-75) + Bar width
(100)).
But my bar is printing from 0 to 75 only. I want to print -75 to 75.How
to display the negative bars in bar chart. Should i have modify the any
objects in xaxixs. pls help.

Ram.


--
ramkumar_cpt
------------------------------------------------------------------------
ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
View this thread: http://www.excelforum.com/showthread...hreadid=492959

How to display the negative bar in bar chart?
 

The bars in a bar chart can be negative or positive, but they will not span
from a negative to a positive. You need to use extra series, one for the
negative part of a bar and one for the positive part. This web page
describes one technique:

http://peltiertech.com/Excel/Charts/...eAndBelow.html

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


"ramkumar_cpt"
wrote in message
news:ramkumar_cpt.1zyr8a_1134452101.7713@excelforu m-nospam.com...

Hello,

I have created one bar chart. but it could not accept negative
values. my x axis range is -150, -100, -50, 0, 50, 100. For example
one of the SeriesCollection(1) value is -75.Bar width is 100. I want to
print the bar from -75 to 75.(Starting position(-75) + Bar width
(100)).
But my bar is printing from 0 to 75 only. I want to print -75 to 75.How
to display the negative bars in bar chart. Should i have modify the any
objects in xaxixs. pls help.

Ram.


--
ramkumar_cpt