[Solved] Bar Charts - plus + minuses

Discuss the spreadsheet application
Post Reply
paulhomewood
Posts: 17
Joined: Fri Oct 12, 2012 2:31 pm

[Solved] Bar Charts - plus + minuses

Post by paulhomewood »

Can I produce a bar chart which shows "minuses" below the line and "pluses" above?

As in the attached graph from the Met Office?
HadCET_graph_ylybars_uptodate.gif
http://www.metoffice.gov.uk/hadobs/hadcet/
Last edited by paulhomewood on Tue Oct 16, 2012 2:30 pm, edited 3 times in total.
OpenOffice 3/vista
User avatar
Hagar Delest
Moderator
Posts: 33625
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Bar Charts - plus + minuses

Post by Hagar Delest »

Just configure your Y axis so that the zero is at the middle of the chart.
Can you upload a sample file with numbers if you're lost (see How to attach a document here)?
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
paulhomewood
Posts: 17
Joined: Fri Oct 12, 2012 2:31 pm

Re: Bar Charts - plus + minuses

Post by paulhomewood »

I have got the Y scale as you suggest. But the bars all go down to the bottom of the grid. The Met graph in contrast has "pluses" that start at zero and go up, and minuses that start at zero and go down.
Thanks

Paul

See my version on the attachment (the graph is third along titled "1659-2011)
Attachments
CET MEANS.ods
(125.86 KiB) Downloaded 109 times
OpenOffice 3/vista
User avatar
Hagar Delest
Moderator
Posts: 33625
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Bar Charts - plus + minuses

Post by Hagar Delest »

Play with the X axis positioning (Y axis to center the 0 and X axis position in its properties):
Chart.png
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
paulhomewood
Posts: 17
Joined: Fri Oct 12, 2012 2:31 pm

Re: Bar Charts - plus + minuses

Post by paulhomewood »

Excellent. Thanks Hagar.
OpenOffice 3/vista
Post Reply