Ask Your Question
0

Can I add custom grid lines? [closed]

asked 2012-10-23 02:08:28 +0100

zorkerz gravatar image

I have a chart showing my households average daily electricity usage for each electricity bill (roughly monthly). The vertical axis is KWH/day and the horizontal is date. In order to make it easier to compare usage year to year I would like to add vertical grid lines separating each year.

When I select the horizontal axis and insert a "Major Grid" or "Minor Grid" it just puts lines between every month (i.e. every data point). This is not helpful. Is there any way to get it to put vertical lines only every 12 data points or even better exactly at the year separation?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-25 05:29:30.963441

Comments

@ horst Sorry I can't comment on your post. Thanks for pointing me in the right direction, however, no matter what chart type I select (bar is preferred) the major and minor intervals always get reset to automatic.

zorkerz gravatar imagezorkerz ( 2012-11-02 18:33:33 +0100 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2013-03-02 14:03:48 +0100

ROSt52 gravatar image

updated 2013-03-02 14:04:46 +0100

@zorkerz I am not sure if I understand your question correct. I followed the hint of @horst and could create the following chart with major grid lined very bold every year and minor grid lines every 6 month.

I did first work on the x-axis format and set the major and minor interval Next I made major and minor grids visible Nest I formated the major grid

As far as I can see Calc offers more possibilities than Excel.

Here is a screen shot of the chart I created:

image description

It should be possible with every chart type as it is a feature of the x-axis

edit flag offensive delete link more

Comments

i am runing LibO Version 3.6.5.2 (Build ID: 5b93205) on XP

ROSt52 gravatar imageROSt52 ( 2013-03-02 14:06:48 +0100 )edit
0

answered 2012-10-23 21:03:39 +0100

horst gravatar image

If you have x-y-scatter chart and the major grid lines displayed, then goto Format -> Axis -> X-Axis and in the tab scale you can set the interval between the major grid lines.

Line Chart: Do the same plus you havr to select "date" in the drop down box of the scale-tab (by default it is set to automatic). Now you can set your major interval as day, month, year .. to change the default values first uncheck the automatic setting.

! Drawback: the label is only displayed at the major grid.

Do not work with other chart types, so don't know but guess it might be similar.

edit flag offensive delete link more
0

answered 2013-03-02 08:11:28 +0100

qubit gravatar image

Hi @zorkerz,

Still having issues? Please try installing the latest release and see how that works for you!

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-10-23 02:08:28 +0100

Seen: 17,649 times

Last updated: Mar 02 '13