graphics scale minimum
 

Hello,

I'm creating a horizontal bar chart. The horizontal axis is a date, and I
want the minimum of the axis to be todays date TODAY() , and the maximum to
be 30 days ahead.

I know how to do this manually, by enterinng the dates via the 'scale'
minimum & maximum tabs, but can it be done automatically ?


I have Excel 2000

Thanks

KK

graphics scale minimum
 

Why not use a defined name for your chart and for your source use
=myworkbook.xls!definedname
=OFFSET(Sheet13!$A$1,MATCH(TODAY(),Sheet13!$A:$A), 0,MATCH(TODAY(),Sheet13!$A:$A)+30,4)

--
Don Guillett
SalesAid Software

"KK" wrote in message
...
Hello,

I'm creating a horizontal bar chart. The horizontal axis is a date, and I
want the minimum of the axis to be todays date TODAY() , and the maximum
to
be 30 days ahead.

I know how to do this manually, by enterinng the dates via the 'scale'
minimum & maximum tabs, but can it be done automatically ?


I have Excel 2000

Thanks

KK

graphics scale minimum
 

Unfortunately, XL doesn't support dynamic axis parameters.

You could use code to do the needful. For a readymade add-in, see
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello,

I'm creating a horizontal bar chart. The horizontal axis is a date, and I
want the minimum of the axis to be todays date TODAY() , and the maximum to
be 30 days ahead.

I know how to do this manually, by enterinng the dates via the 'scale'
minimum & maximum tabs, but can it be done automatically ?


I have Excel 2000

Thanks

KK