I successfully used Debra Dalgleish's method to create a
dynamic chart where my data was in columns. When I try to
apply the same approach to data that is ROWS, it doesn't
work. In fact my x axis labels should be Monday, Tuesday,
Wednesday, etc, but on the chart they are Monday, 4.6,
space, space, June 24 etc as it is looking downwards
rather than across. Any ideas, anyone. Thanks.