Warning typo - both columns were intended to be on the same Sheet1 I only see typos after sending them - proving Murphy's principle dayly
On Mon, Feb 24, 2020, 17:43 Tomas Kuchta <[email protected]> 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 <[email protected]> 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 >> [email protected] >> http://lists.pdxlinux.org/mailman/listinfo/plug >> > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
