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