Ask Your Question

How to select axis values? [closed]

asked 2014-05-16 05:56:38 +0100

arnoldpredator gravatar image


I will try to explain it. I have two columns with data, the first column contains the data I am interested in, the second has the time in hours associated.

When I make column chart the problem is that if I select both columns the graph shows both as if they were data, but I want the second column not to be displayed graphically, I want that data to be on the x axis, just to know when the data on the Y axis happened.

Imagine that you have hourly data from several days, I want the x axis to show 0, 1, 2... 23, 0, 1, 2... 23 repeatedly, but know I get 0,1,2,3,4..145,146,147 and that is not what I want.

I hope you underestand, if not let me know and I will try to explain it better.


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 2016-02-22 17:34:36.067609

2 Answers

Sort by » oldest newest most voted

answered 2014-05-16 06:54:33 +0100

ROSt52 gravatar image

Select our data > create chart as it comes up > click on your chart > Edit (you must then have a dark gray frame with little black handles) > right click >select Data Ranges

Here you can select and specify whatever you need. Note: "Category" means the x-axis.

LibO is very flexible and simple here. Have fun.

edit flag offensive delete link more

answered 2014-05-17 08:45:34 +0100

arnoldpredator gravatar image


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-16 05:56:38 +0100

Seen: 96 times

Last updated: May 17 '14