Limiting the frequency of categories (on x-axis) in Chart

Question

Level 1

12 points

Limiting the frequency of categories (on x-axis) in Chart

My chart has a lot of data (years 1850-present) and the x-axis (years) is way too cluttered. There's so many years down there it looks like one big grey bar. Is there a way to limit the labeling to every 10 years, or some other solution? I've tried playing with my data in the table, but it's no use.

p.s. I tried to post a pic of this problem, but it wouldn't let me. If that's possible and it would help, just say the word. thanks!

15" 2.53 GHz MacBook Pro, unibody, Mac OS X (10.5.5), 4GB, glossy, 7200rpm drive

Posted on Dec 2, 2008 8:18 AM

Reply

Answer 1

Best reply

KOENIG Yvan

Level 8

41,807 points

Dec 2, 2008 9:17 AM in response to rpmca

You may chart with a first column containing only the numbers of years ending by zero.

You may also chart several groups separately.

Yvan KOENIG (from FRANCE mardi 2 décembre 2008 18:06:28)

Reply

Answer 2

Dec 2, 2008 11:55 AM in response to rpmca

rpm,

Numbers will try to space out your x-axis labels, but you may have to help out by formatting them as either diagonal or vertical. If you select your chart and grab a sizing handle, you can stretch or compress the width of the chart and you will notice the number of axis labels changing.

In the Chart Inspector, Axis Tab, click the X-Axis control and select Vertical Labels.

Jerry

Reply

Answer 3

rpmca Author

Level 1

12 points

Dec 2, 2008 7:39 PM in response to Jerrold Green1

That's what I imagined should happen. But instead when I stretch out the size of the chart, the labels along the bottom just get a little more room to breath. But the same amount is there regardless of how small the chart is... is something wrong with my software maybe?

Reply

Answer 4

KOENIG Yvan

Level 8

41,807 points

Dec 3, 2008 1:56 AM in response to rpmca

Thanks to Jerry, I learnt something.

Here is a single chart.

Yvan KOENIG (from FRANCE mercredi 3 décembre 2008 10:55:56)

Reply