First time here? Check out the FAQ!
asked 2012-10-23 02:08:28 +0200zorkerz
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?
@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:
It should be possible with every chart type as it is a feature of the x-axis
answered 2012-10-23 21:03:39 +0200horst
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-10-23 02:08:28 +0200
Seen: 485 times
Last updated: Mar 02