software

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: www.excelforum.com/member.php...oamp;userid=28673
View this thread: www.excelforum.com/showthread...hreadid=492959The 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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;ramkumar_cptquot; gt;
wrote in message
news:ramkumar_cpt.1zyr8a_1134452101.7713@excelforu m-nospam.com...
gt;
gt; Hello,
gt;
gt; I have created one bar chart. but it could not accept negative
gt; values. my x axis range is -150, -100, -50, 0, 50, 100. For example
gt; one of the SeriesCollection(1) value is -75.Bar width is 100. I want to
gt; print the bar from -75 to 75.(Starting position(-75) Bar width
gt; (100)).
gt; But my bar is printing from 0 to 75 only. I want to print -75 to 75.How
gt; to display the negative bars in bar chart. Should i have modify the any
gt; objects in xaxixs. pls help.
gt;
gt; Ram.
gt;
gt;
gt; --
gt; ramkumar_cpt