Chart line with min max area

Discuss the spreadsheet application

Chart line with min max area

Postby Carter7Gindenv » Tue Dec 04, 2018 12:25 pm

Hello, is there a way to create a chart with 3 line ( max - average - min ) and have the area of the min-max greyed to highlight that interval?
e.g. ... risons.png

thanks and have a nice day
openoffice 4.1.4 win7
Posts: 4
Joined: Thu Nov 15, 2018 3:32 pm

Re: Chart line with min max area

Postby jrkrideau » Tue Dec 04, 2018 4:43 pm

I almost never use Calc plots so I am not at all an expert but I doubt it. Maybe you could graph the three lines and use Draw to supply shading?

I would suggest going to a proper scientific graphing package to do this. I am not sure but at a quick guess that plot example you posted may be from gnuplot (Perhaps Pyhton with gnuplot as its graphics component?). See Error on y represented by filledcurve shaded region --scroll to bottom of the page.

It also seems fairly easy to do using the ggplot2 graphing package {with the geom_ribbon() function} in the stats and graphics system R. See the extremely quick and dirty example in the attached file. The lines are parallel simply because that was the easiest way to generate some data.
ribbon.png (5.93 KiB) Viewed 152 times
OpenOffice 4.1.6; Ubuntu 18.04
Posts: 3686
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests