Ask Your Question
0

Edit data labels in x-axis (interval) [closed]

asked 2012-02-20 12:21:08 +0200

Maruku gravatar image

Hello,

I have a data series from 1970 to 2004, but the intervals are irregular. So there is one value for 1973, but none for 1974 and two for 1975, one for 1976, ect. My chart now looks very cluttered with tons of labels on the x-axis.

I want to include all the values in the line chart, but I don't want the have all years as labels in the x-axis. Is there any way to do this? Can I choose which x-values show up on the axis?

Thanks very much!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 15:33:17.409060

Comments

Just wanted to mention that I spent a lot of time, trying to fix that for NOT XY Scatter chart. If you want to set the values for the X axis on different chart, simply go to: Data Ranges >> Data Series, and type in the "Category" field the appropriate column in the sheet you want to use ($'DataRange'.$I$18:$I$47)

pastet89 gravatar imagepastet89 ( 2015-12-16 22:03:04 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2012-02-20 14:51:47 +0200

cloph gravatar image

you probably don't want a line-chart, but a x/y chart with the style set to show lines instead of individual dots.That way the dates get properly spaced into time, and not spaced evenly as would be the case with a line-chart.

edit flag offensive delete link more
0

answered 2012-02-22 11:03:05 +0200

Maruku gravatar image

I have been playing around with the x/y chart, but had no success. The line chart picks automatically the years as labels for the x-axis, but the x/y chart shows up with identical horizontal and vertical axis unrelated to my data.

Also, the problems with the line chart was not that the years were not properly spaced into time, but that too many years leads to too many labels, so a cluttered axis.

edit flag offensive delete link more
0

answered 2012-03-14 06:52:16 +0200

You should choose a Chart Type - Format > XY scatter. It will allow you to format the increments on each axis as you want to. Right click X or Y axis and Format Axis > Scale.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-02-20 12:21:08 +0200

Seen: 16,875 times

Last updated: Mar 14 '12