Chart non-adjacent data in Excel

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.

How can I chart non-adjacent data?

Chart non-adjacent data in Excel

It's common to want to produce an Excel 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.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


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


Guru Spotlight
Heidi Splete