Chart Question

[Joneye]

I have some simple data, its automated so its updated via a ODBC link.

My problem is I have a smiple bar graph the order in which the data arrives in is never high to low so my graph looks untidy.

Is there a way in graph settings to always have the largest numbers first following to the smallest rather than me data sorting the table?

PS using excel 2003.

 

[Expiry]

No, but you could set up a second dataset that the chart works from. You could use the =LARGE() function on your data so that the largest is always in row 2, for example, and build it up with lookups.

 

[Joneye]

That sounds better than the macro I wrote, ill look into this large feature.

Many thanks