View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ramkumar_cpt
 
Posts: n/a
Default 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