Prev: Pivot Chart won't refresh!
Next: Swapping headers
From: Andrew Lavinsky on 22 Jan 2010 14:50
Excel 2007 (or 2010 Beta, if that's the only way to do it)

I've developed a Gantt Chart using a stacked bar chart. It works great.

Is there any way to have the horizontal axis (or vertical axis, I get
confused with the terms in a stacked bar chart) expand in and out based on
the MIN and MAX of the dates in the plotted range?
From: Herbert Seidenberg on 22 Jan 2010 22:21
Excel 2007 Gantt Chart
Scale X axis with macro.
http://www.mediafire.com/file/zdzj4tz2mmo/01_22_10.xlsm
From: Andrew Lavinsky on 31 Jan 2010 07:51
Thanks! Will try that out.

"Herbert Seidenberg" wrote:

> Excel 2007 Gantt Chart
> Scale X axis with macro.
> http://www.mediafire.com/file/zdzj4tz2mmo/01_22_10.xlsm
> .
>
 | 
Pages: 1
Prev: Pivot Chart won't refresh!
Next: Swapping headers