Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

MasterHowl

macrumors 65816
Original poster
Oct 3, 2010
1,067
182
North of England
Hello!
I'm doing a presentation, and I'd like to include a bar graph of world population trends. I created a bar chart to show the data, but I need the x-axis to be "to scale", asin, have the correct amount of space between the bars.
This is it so far:
http://public.iwork.com/document/?a=p215536326&d=Pop_Trends.numbers
I need the gap between "Year 1" and "Year 1500" to be 1500 years! Not the same distance between the year 2006 and 2009, if you get what I mean?
Thank you!
 
I would think you may need to add additional years between the years 1 and 1500, as you have between 1500 and 2050. Numbers just sees them as numbers and not years.
 
So I need to add 1499 cells between the two values? D:

I don't think so, but as you used variable time spans between the later years, maybe emulate those spans with the earlier years. Maybe 100 or 50 year steps, as you have varying steps throughout the chart (1000, 500 150, 100, 50, 10 years).

With D:, did you mean :D? :D
 
I don't think so, but as you used variable time spans between the later years, maybe emulate those spans with the earlier years. Maybe 100 or 50 year steps, as you have varying steps throughout the chart (1000, 500 150, 100, 50, 10 years).

With D:, did you mean :D? :D

good idea, I'll try this one out, thanks!

I meant "D:". it's a shocked face :)
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.