graphics scale minimum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KK - 28 Oct 2006 12:59 GMT

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

Reply to this Message

Don Guillett - 28 Oct 2006 13:58 GMT

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)

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
>
[quoted text clipped - 11 lines]
>
> KK

Reply to this Message

Tushar Mehta - 28 Oct 2006 16:35 GMT

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/software/autochart/index.html

Signature

Regards,

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

> Hello,
>
[quoted text clipped - 10 lines]
>
> KK

Reply to this Message

Rate this thread: