control chart scale with cell value in excel
 

I would like to control the Min. and Max. values for the x & y axes in a XY
scatter chart with cell values.
Does anybody know how to do this?

Excel 2003

control chart scale with cell value in excel
 

jjw:

Here's a post that shows a simple[le VBA approach.

http://processtrends.com/pg_charts_s..._max_dates.htm

Kelly O'Day

http://processtrends.com

"jjw" wrote in message
...
I would like to control the Min. and Max. values for the x & y axes in a XY
scatter chart with cell values.
Does anybody know how to do this?

Excel 2003

control chart scale with cell value in excel
 

Kelly, thank you

"Kelly O'Day" wrote:

jjw:

Here's a post that shows a simple[le VBA approach.

http://processtrends.com/pg_charts_s..._max_dates.htm

Kelly O'Day

http://processtrends.com

"jjw" wrote in message
...
I would like to control the Min. and Max. values for the x & y axes in a XY
scatter chart with cell values.
Does anybody know how to do this?

Excel 2003