Forum

 
  Back to OzPolitic.com   Welcome, Guest. Please Login or Register
  Forum Home Album HelpSearch Recent Rules LoginRegister  
 

Page Index Toggle Pages: 1
Send Topic Print
Assistance for charting (Read 311 times)
Sprintcyclist
Gold Member
*****
Offline


OzPolitic

Posts: 41796
Gender: male
Assistance for charting
Dec 9th, 2023 at 1:17pm
 
I want to chart these figures on a chart. Aside from doing it by hand, can I do it on the computer?

I want these sorts of figures in a OHLC chart


Thursday, 21 September 2023      6.05230
Wednesday, 20 September 2023      6.06430
Tuesday, 19 September 2023      6.07440
Monday, 18 September 2023      6.11770
Friday, 15 September 2023      6.05840
Thursday, 14 September 2023      6.05650
Wednesday, 13 September 2023      6.08100
Tuesday, 12 September 2023      6.04500
Back to top
 

Modern Classic Right Wing
 
IP Logged
 
lee
Gold Member
*****
Offline


Australian Politics

Posts: 20958
Gender: male
Re: Assistance for charting
Reply #1 - Dec 9th, 2023 at 4:27pm
 
Using Win Excel or Libre or Open Office.

Place your data in the grids

Highlight the data

In LibreOffice open up Insert and then Chart. You will have a selection of chart types to use from.

I don't use Excel anymore but it is similar.
Back to top
 
 
IP Logged
 
Sprintcyclist
Gold Member
*****
Offline


OzPolitic

Posts: 41796
Gender: male
Re: Assistance for charting
Reply #2 - Dec 9th, 2023 at 7:35pm
 
lee wrote on Dec 9th, 2023 at 4:27pm:
Using Win Excel or Libre or Open Office.

Place your data in the grids

Highlight the data

In LibreOffice open up Insert and then Chart. You will have a selection of chart types to use from.

I don't use Excel anymore but it is similar.


Wow - thanks
Back to top
 

Modern Classic Right Wing
 
IP Logged
 
Sprintcyclist
Gold Member
*****
Offline


OzPolitic

Posts: 41796
Gender: male
Re: Assistance for charting
Reply #3 - Dec 9th, 2023 at 7:48pm
 
Thanks, I had a look. It may not do exactly what I want.
It's not that I am overly fussy, but this is what I want

https://datavizcatalogue.com/methods/images/top_images/SVG/OHLC_chart.svg

https://datavizcatalogue.com/methods/OHLC_chart.html
Back to top
 

Modern Classic Right Wing
 
IP Logged
 
lee
Gold Member
*****
Offline


Australian Politics

Posts: 20958
Gender: male
Re: Assistance for charting
Reply #4 - Dec 9th, 2023 at 7:56pm
 
You can get templates for stocks etc for excel, LibreOffice calc.
Back to top
 
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Print