|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 22nd, 2010, 07:50 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamically Scale Gantt Chart Time Scale
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? 
|
|
#2
January 23rd, 2010, 03:21 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamically Scale Gantt Chart Time Scale
Excel 2007 Gantt Chart
Scale X axis with macro. http://www.mediafire.com/file/zdzj4tz2mmo/01_22_10.xlsm
|
|
#3
January 31st, 2010, 12:51 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamically Scale Gantt Chart Time Scale
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 .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
