How do I make X-values of a chart dependent on values in cells?

[Kashgarinn]

Greetings.

I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.

Is it possible to do that?

Thanks for any replies.

K

 

[Andy Pope]

Hi,

There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
(http://www.tushar-mehta.com/)

Cheers
Andy

 

[Kashgarinn]

Thanks alot. It works.

Will it only work for people who have the add-in?

If so, I might need a VBA solution I can have with my sheet as other
will be viewing it.

K

 

[Andy Pope]

You should not need the addin for those who are just viewing.

Here is an example of the VBA needed, courtesy of Jon Peltier.
(http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html)

Cheers
Andy

 

[Jon Peltier]

I show the technique on this page if anyone wants to construct it
themselves:
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Hi,

There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
(http://www.tushar-mehta.com/)

Cheers
Andy