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