View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Matt McQueen Matt McQueen is offline
external usenet poster
 
Posts: 23
Default Chart Type - numeric values

Andy,

SeriesCollection(x).ChartType looks good, but I think there'd be problems
when you've got things like area plots, since they may or may not have the
values I was looking for (i.e. .ChartType may return 76, but this doesn't
mean there's a minimumscaleisauto value). I think this just indicates that
ChartType (for the chart or the series) is not going to provide what I want.

Writing some error handling code looks like the way to go, since it'll
always generate an error. I'd sort of given up on it when I read in the
help-file that a 1004 error was not a trappable one, but I'll read up on it
and give it a bash. Any tips?

Cheers,

Matt