Does it work with or without Sheet1 address?
On Tue, Feb 25, 2020, 07:25 Richard Owlett <[email protected]> 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 <[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
