Make line chart with array data

How To
1

i have an array of prices and i want to create a Line Chart (jpg format or URL)
ive used chatgpt DallE but every time it gives me a different result
i want to create Line chart every hour with my data but i cant get consistant result from chatgpt
any idea how can i do this task?
i attached a line chart so you know exactly what kind of chart i mean

line_chart (1)
line_chart (1)3000×1800 262 KB

2

Hey @alireza_soleimanikha
Instead of creating the array, upload the same data in google sheets and create a chart using appscript
that will much better and accurate

2 Likes
3

actually i want to use the image in Telegram thats why i need the URL
the data i have is an array of Prices in the past 10 days and i want to post the Line Chart in Telegram
what should i do now?

4

Hey, @alireza_soleimanikha

I suggest you to use Google Sheets along with Google Apps Script.

  1. Prepare your data: Make sure your array of prices is stored in a Google Sheets spreadsheet.
  2. Create a Line Chart in Google Sheets: Manually create a line chart in Google Sheets using your data.
  3. Automate the process using Google Apps Script:
    Write a Google Apps Script function to update your data and regenerate the chart.
    Set up a trigger to run the script hourly.
  4. Publish the chart: Once the chart is generated, you can publish it to get a consistent URL that you can use.

example of what the Google Apps Script might look like

image
image1087×741 24.5 KB

please let me know if this works !

2 Likes