$$Excel-Macros$$ Decrease the gap between bars in Bar Chart

2011-09-07 Thread Ramanjaneya Reddy
Is there any way to decrease the gap between bars (NOT the width of the bars) of excel bar chart? I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007, 10/19/2007 etc.). The row were very thin and the gap between the rows is long. Can we decrease the gap between the bars to make it lo

Re: $$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

2011-04-06 Thread Ramanjaneya Reddy
, ANJI On Sun, Apr 3, 2011 at 12:03 AM, ashish koul wrote: > > created two pivots see if it helps > On Thu, Mar 31, 2011 at 10:02 AM, Ramanjaneya Reddy > wrote: > >> Hi Experts, >> >> Thank you so much in advance. Please help me on this. >> >> >>

$$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

2011-03-31 Thread Ramanjaneya Reddy
Hi Experts, Thank you so much in advance. Please help me on this. Attached is the sampled data. This is the generated report from tool upto column A to G. Column H & I are formulated columns by me. Expected output from the report (When i run the macro) 1. Details to be listed in same w