Search results for query: *

Hi, I am recording results of matches between various teams in various tournaments. My columns for the score table are HomeTeam, AwayTeam, Tournament, HomePoints, AwayPoints. e.g. HomeTeam|AwayTeam|Tournament|PointsHome|PointsAway ---------------------------------------------------------- A...

Yes I did, read my 2nd post It will still be interesting to see if this is an issue with Excel 2007.

It just records the selecting: ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(2).Select

I guess you are not using Excel 2007?

I did change the color.

Yes I tried that - unfortuantely, for reasons best known to Microsoft, the color change does not get recorded. I have since discovered you can do it by setting the ColorIndex property of the associated Border object.

Hi, I'm trying to programatically change the color of lines in a line graph using a VBA macro in Excel. Is this actually possible?

Sorry - obviously it doesn't - I just listed it twice by mistake.

Thanks, but gives the error message: The column 'TrialId' was specified multiple times for 'Test'.

Hi - I'm struggling with a query, which is as follows. (I have changed the context slightly for simplicity) I have 4 tables: users, scores, trials, tests Each pair of users takes a series of upto 4 tests in 1 trial, getting a score for each test. There are a different numbers of trials for each...