August 28, 2009, Newsletter Issue #322: Chart non-adjacent data in Excel

Tip of the Week

Itīs common to want to produce a chart that shows only some of your data, but you donīt need to rearrange or manipulate your data to achieve this.

To select non-adjacent data (for example rows 2, 4 and 6 of your data), select the first required row, hold down the Ctrl key and select the second, then the third etc.

Then create the chart in the usual manner.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!

Guru Spotlight
Mary White