Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Data Visualization with Excel Practicing Data Visualization in Excel Solution: Population Growth

Riccardo Lovo
Riccardo Lovo
1,160 Points
Posted by Riccardo Lovo
Riccardo Lovo
1,160 Points

Hi, how would you select data every 5 years (or any interval)?

Can you do so without having to create another table and in a very efficient way? Thank you

3 Answers

Richard Button
Richard Button
12,968 Points
Richard Button
Richard Button
12,968 Points

select x-axis -> Format Axis -> Expand Labels -> Change "Specify interval unit" to 5.

Steve Nicksic
Steve Nicksic
8,968 Points
Steve Nicksic
Steve Nicksic
8,968 Points

I would like to know as well. One thing I did was to select the x-axis, right-click and select "select data". There I just checked the boxes for every 5 years but it only let me go so high until I got to the year 2000, then the check boxes were no longer available.

megm
megm
14,342 Points
megm
megm
14,342 Points

I am unable to change the interval on the X-axis. When I expand the Labels (select x-axis -> Format Axis -> Expand Labels), the only option that I have is to change the label position. Is there somewhere else I should be looking on Excel to change the interval?