X Axis Values based on Cell Values - Chart

[Smergen]

Hi Gang,

Just a quick query to see if there is a simple way to have the X axis of an X-Y plot dependant on cell values in a worksheet?

In reference to my problem, I have a rather lengthy long section and wish 'zoom' in on certain sections of the graph. Obviously I can do this by changing the values within the chart properties but was wondering if there is a quicker way.

Any thoughts on the matter would be appreciated.

Cheers,

 

[Jon Peltier]

You mean the X axis scale?

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

 

[Smergen]

Thanks Jon, I do mean the X-axis. I think your link has the right answer as well. I'll let you know how I get on.

Cheers,

 

[Smergen]

Jon,

Thanks for those solutions, they seem to do the trick. I'll probably tailor the macro solution, but very handy indeed.

Cheers,

Smerg