Setting chart scale min/max in VBA
 

Would like to set the scale on several different charts in the same
workbook based on min and max values in a data range. Can do it
manually but it would be nice to automate it. Any help?

Setting chart scale min/max in VBA
 

Hi,

See Jon's page,
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

wrote:
Would like to set the scale on several different charts in the same
workbook based on min and max values in a data range. Can do it
manually but it would be nice to automate it. Any help?

Setting chart scale min/max in VBA
 

Here's an example of setting min and max dates for a trend chart.

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

Kelly O'Day

http://Processtrends.com



"Andy Pope" wrote in message
...
Hi,

See Jon's page,
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

wrote:
Would like to set the scale on several different charts in the same
workbook based on min and max values in a data range. Can do it manually
but it would be nice to automate it. Any help?