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 2000 and other Software topics.

How can I chart non-adjacent data?

Chart non-adjacent data in Excel

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.



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


URL: (optional)


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

Guru Spotlight
Ray Lokar