4 Replies Latest reply: Dec 3, 2008 1:56 AM by KOENIG Yvan
rpmca Level 1 (0 points)
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
  • Level 8 (41,790 points)
    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)
  • Jerrold Green1 Level 7 (29,960 points)
    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
  • rpmca Level 1 (0 points)
    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?
  • Level 8 (41,790 points)
    Thanks to Jerry, I learnt something.

    Here is a single chart.



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