control chart scale with cell value in excel

jjw · Nov 8, 2007

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

Kelly O'Day · Nov 8, 2007

jjw:

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

http://processtrends.com/pg_charts_set_x_axis_min__max_dates.htm

Kelly O'Day

http://processtrends.com

jjw · Nov 9, 2007

Kelly, thank you

Kelly O'Day said:
jjw:

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

http://processtrends.com/pg_charts_set_x_axis_min__max_dates.htm

Kelly O'Day

http://processtrends.com

jjw said:

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

Click to expand...