Re: New to Gnumeric -- attempting to plot data
Raymond Lillard <[email protected]> Wed, 26 Feb 2020 10:58:08 -0700
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <[email protected]> |
Richard, Gnumeric has been my goto spreadsheet for a long time. I have used it as the first step in making quality plots in published papers. First I use the plot tools to take my graph as far as makes sense, adding axis-es, labels trend-lines etc.. as desired. I then export the plot by saving it in the svg graphics format. I then polish it off in Inkscape. The final result looks better than anything I know how to do with any other tool set including Excel. Regards, Raymond On 2/26/20 4:39 AM, Richard Owlett wrote: > Thank you. > When I first read your post yesterday my initial response was > <sputter> <sputter> I tried that <sputter> <sputter> <sputter> > > *THIS morning*, after a night's sleep, I followed your procedure > STEP by STEP. It worked better that way <sheepish grin> > > The key was Step 6. > > The manual needs a redo > > On 02/25/2020 09:09 AM, Adrian Custer via gnumeric-list wrote: >> On 2/25/20 11:05 AM, Jean Brefort wrote: >> ... >> > Welcome to Gnumeric. >> >> >> Yeah, welcome. >> >> 1) Select A30:A65 >> 2) Hold <Ctrl>, select C30:C65 >> 3) Click the graph icon, >> => should give you a plot of type "XY" in a preview window >> >> 4) click insert >> 5) Select an area of the worksheet (click-drag-release) >> => should give you a plot on the worksheet >> >> 6) Right click on the plot, select "Properties" from the pop-up menu >> => gives you a "customize chart" window >> >> This is a little complex: At the top left, there is a tree of >> elements in your chart, you can navigate it and add or remove >> elements to the tree. Top right, is a preview; bottom, allows you to >> modify the currently selected element. >> >> Off the top of my head, I don't know how to get the labels you want. >> Best play around for a while to get a feel for it. Be patient, it's >> not intuitive because it is trying to do something complex and has >> its own vocabulary for all the elements. >> >> good luck, >> ~adrian >> >> >> >>> >>> Look at section 3.10 (Graphing). >>> >>> The fast way to plot your data is to select both ranges and click on >>> the graph button (left to the zoom tool button). Next, you choose the >>> plot type, default being scatter plot, and you can use the dialog to >>> customize your plot. >>> >>> Hope this helps, >>> Jean >>> >>> Le mardi 25 février 2020 à 06:52 -0600, Richard Owlett a écrit : >>>> Although I used spreadsheets back in days of CPM/80 and WinXP, >>>> I've not used any in *DECADES*. >>>> My OS is Debian Stretch (9.8). >>>> The version of gnumeric is 1.12.32 . >>>> >>>> I wish to plot the data in C30:C65 against the data in A30:A65. >>>> I wish the labels on the x-axis to run from the value in A30 to >>>> the value in A65. >>>> >>>> I do not find the manual at >>>> https://help.gnome.org/users/gnumeric/stable/gnumeric.html >>>> very helpful. >>>> >>>> Help please. >>>> TIA > > > > _______________________________________________ > gnumeric-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list