O'Reilly logo

Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond by Reinhold Scheck

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automatic Sorting of Chart Content

In a lot of chart content, the graphic quality of the chart changes considerably when the data series elements are sorted in different ways in order to make the content easier to understand or to change the point of view (however we may interpret this term).

This can be done relatively easily for your own visual information by sorting the data source. Of course, you can’t do that in a presentation, which means you need an efficient and safe way to sort your information without having to exit the chart. In most cases, you do not need programming, which shouldn’t surprise you by now.

I’ll introduce two procedures that you can use to automatically sort your tabular chart basis:

  • You deploy controls to use a sort sequence ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required