Prev: Not plotting null or text data
Next: Traffic light problem
From: Vince F on 27 Jun 2008 12:22
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.
--
Vince F
From: Andy Pope on 27 Jun 2008 14:39
Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy

Vince F wrote:
> Since I got instant help on my last query, is there any way to use a cell
> reference as an axis minimum or maximum in format axis? It seems impossible,
> but there is a lot of experience out there. Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
From: Vince F on 28 Jun 2008 06:19
Andy
Thanks. I have handed this off to our local VBA expert and he says this
should do it. Take care.
--
Vince F


"Andy Pope" wrote:

> Hi,
>
> See Jon's information
> http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
>
> Cheers
> Andy
>
> Vince F wrote:
> > Since I got instant help on my last query, is there any way to use a cell
> > reference as an axis minimum or maximum in format axis? It seems impossible,
> > but there is a lot of experience out there. Thanks in advance.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
 | 
Pages: 1
Prev: Not plotting null or text data
Next: Traffic light problem