Plotting date data

clem padin shared this question 1 year ago
Needs Answer

Hi

I have a bunch of points over several days that I want to plot. I've googled, searched youtube and the manual and can't seem to find out how to do this. It can't be that hard. Can someone point me to some documentation on this or how to do it?

Thanks!

clem

Comments (4)

photo
1

Please post the data

photo
1

Here's a sample

March 10, 2020, 155

March 11, 2020, 167

March 12, 2020, 180

... etc.

thanks.

photo
1

Your specifications are very poor and I had to make many assumptions for the sample in the appendix.

Below are some notes:

The import of the columns (A,B,C) is cleaned up manually (missing date to be added, blank rows deleted)

Column D is initiated in rows 1 and 2 (Numeric-Value !) and the rest is copied (relative) down.

(select cells D1 and D2, drag and drop down the small black square below right)

Column E is initiated in row 1 and the rest is copied (relative) down.

(select cell E1 drag and drop down the small black square below right)

l1 = Zip(Text(RotateText(D, 90°), (n - 0.1, -20), true, true), D, E1:E3, n, D1:D3)

l2 = Zip((n, Y), Y, C1:C3, n, D1:D3)

must be adjusted in the highlighted values by you

Search for GGB commands you don't know in the manual. Study them until you understand them.

The handling of spreadsheets is documented here and here.

You can find most of GGB-Information with Google. Example: Geogebra Zip or Geogebra RotateText

If necessary ask additional questions in this thread with the current state of your application as GGB file (no screenshot)

photo
1

Sorry if I made this sound confusing but the dataset is insanely simple -- The x-axis value is the dates and the y-axis value are integers. So in my example database, there are the points I want to plot:

pt1: (x=March 10, 2020, y=155)pt2: (x=March 11, 2020, y=167)

pt3: (x=March 12, 2020, y=180)

...etc.

I just haven't found a way to make the x-axis a date axis, listing a collection of consecutive dates.

thanks

clem

photo
© 2021 International GeoGebra Institute