[PLUG] {RESOLUTION} Re: Plotting data - was [ RE-introduction to spreadsheets after decades ; /]

Richard Owlett rowlett at cloud85.net
Wed Feb 26 12:00:59 UTC 2020


On 02/26/2020 04:11 AM, Richard Owlett wrote:
> On 02/25/2020 10:20 AM, Tomas Kuchta wrote:
>> Does it work with or without Sheet1 address?
> 
> When I said "...does not seem to have anything that matches your 
> description", I meant I don't see anything either in the manual nor in 
> meandering through the gnumeric screen(s) anywhere one would enter both 
> abscissa and ordinate at the same time.
> What software are you using?
> 
> Is a spreadsheet even suitable for my plotting task?
> I wish to plot only 5% to 10% of my available data.
> I.E. I want a "magnifying glass" over a small region.
> 

A post on the gnumeric-list mailing list (gnumeric-list at gnome.org) got 
me pointed in the right direction.
Basically manual Section  10.4. Configuring Graph Element Properties 
needs a rewrite. Also that manual needs an index.
Thanks


>>
>>
>>
>> On Tue, Feb 25, 2020, 07:25 Richard Owlett <rowlett at cloud85.net> wrote:
>>
>>> On 02/24/2020 04:46 PM, Tomas Kuchta wrote:
>>>> Warning typo - both columns were intended to be on the same Sheet1
>>>>
>>>> I only see typos after sending them - proving Murphy's principle dayly
>>>
>>> <chuckle> I had wondered about that ;/
>>>
>>> More serious problem - the manual at
>>>    https://help.gnome.org/users/gnumeric/stable/gnumeric.html
>>> does not seem to have anything that matches your description.
>>>
>>> What software are you using?
>>>
>>>>
>>>> On Mon, Feb 24, 2020, 17:43 Tomas Kuchta <tomas.kuchta.lists at gmail.com>
>>>> wrote:
>>>>
>>>>> Select the first Data column then select your other data column while
>>>>> holding Ctrl key.
>>>>>
>>>>> Alternatively, you could describe the selection as:
>>>>> =Sheet1!$A$1:$A$17,Sheet2!$C$1:$C$17
>>>>> in data sources for your graph.
>>>>>
>>>>> Tomas
>>>>>
>>>>> On Mon, Feb 24, 2020, 08:30 Richard Owlett <rowlett at cloud85.net> 
>>>>> wrote:
>>>>>
>>>>>> On 02/22/2020 06:38 AM, Richard Owlett wrote:
>>>>>>> I've not used a spreadsheet in THIS *CENTURY*.
>>>>>>> I have forgotten much.
>>>>>>>
>>>>>>
>>>>>> Rich Shepard's answer of 2/22 allowed me to select appropriate 
>>>>>> data for
>>>>>> a calculation. A simple plot demonstrated I didn't know as much about
>>> my
>>>>>> data as a thought I did. That suggested a different calculation. I 
>>>>>> wish
>>>>>> to plot that 2nd calculated series.
>>>>>>
>>>>>> Column A has values for x-axis on all potential plots.
>>>>>> Column B has values for the first calculation
>>>>>> Column C has values for the 2nd calculation.
>>>>>>
>>>>>> Plotting "B" vs "A" was no problem as they were adjacent columns.
>>>>>> Now I want to plot a portion of "C" vs "A".
>>>>>>
>>>>>> I.E.
>>>>>> my original plot used data from $B$1:$B$285 vs $A$1:$A$285
>>>>>> my new plot should be of $C$30:$C$60 vs $A$30:$A$60
>>>>>>
>>>>>> HOW?
>>>>>>
>>>>>> Should be in manual.
>>>>>> *HOWEVER*
>>>>>> [
>>>>>>
>>> https://help.gnome.org/users/gnumeric/stable/gnumeric.html#sect-graphs-preselect 
>>>
>>> ]
>>>>>>
>>>>>> states "This section is not yet written" :{
>>>>>>
>>>>>> TIA






More information about the PLUG mailing list