[PLUG] Plotting data - was [ RE-introduction to spreadsheets after decades ; /]

Tomas Kuchta tomas.kuchta.lists at gmail.com
Mon Feb 24 22:43:04 UTC 2020


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
>
> _______________________________________________
> PLUG mailing list
> PLUG at pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>



More information about the PLUG mailing list