Advice /guidance on making a graph from range of numbers

Discuss the spreadsheet application

Advice /guidance on making a graph from range of numbers

Postby phillmobile » Sat Feb 23, 2019 3:00 am

Hi this is my first post

I want to see if any one had any guidance for me on how to make achart / graph with data from the 2 rows in my data file to make it look like or similar to the traffic images enclosed

For example the users 10100 and 10101 would have a line linking them to 21000and uses 10200, 10201 would have a line linking to 22000 so the information on the sheet can be visually represented.

the images are from some radio decoding software but the numbers i am trying to make in to a graph are for a different type or radio system and wont work on the software that makes the charts.

I will attempt to make the file work on the old software but cant do that until later in the weekend.

Thanks if you can help i have looked and read about it but maybe i am looking in the wrong place or maybe it just can not be done

Phill H, UK
Attachments
traffic.png
traffic.png (7.26 KiB) Viewed 159 times
data.ods
(8.19 KiB) Downloaded 7 times
0191_ALL_traffic_181023_165657.png
OpenOffice 4.1.5 Windows 10
phillmobile
 
Posts: 1
Joined: Sat Feb 23, 2019 2:34 am

Re: Advice /guidance on making a graph from range of numbers

Postby John_Ha » Sat Feb 23, 2019 12:48 pm

It cannot be done with Calc. See the manual for all charting options.

You will find much useful information in the User Guides, the Writer, Base and Calc Tutorials and the AOO Frequently Asked Questions. May I suggest you bookmark the pages.

phillmobile wrote: the numbers i am trying to make in to a graph are for a different type or radio system and wont work on the software that makes the charts.

Can you change the numbers so they do work?
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6467
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Advice /guidance on making a graph from range of numbers

Postby Zizi64 » Sat Feb 23, 2019 5:41 pm

Can you upload data range of the "graph" here?

You can display the points if you calculate the points of a circle in a helper table. But displaying the lines will be more difficult. It is depend on the data structure of the graph...
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.1 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7769
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Advice /guidance on making a graph from range of numbers

Postby jrkrideau » Sat Feb 23, 2019 7:30 pm

I am with John_Ha. It cannot be done in Calc.
You need a more sophisticated graphing package and probably a better data handling one as well.
You might want to have a look at Octave.

What is the source of those images? It looks to me as if they have been created with something like Gnuplot. The layout and printing has a Gnuplot look to it. I think that Matlab, Octave and Python all use Gnuplot as their graphics module so this seems likely.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3665
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 14 guests