Re: [libreoffice-users] drawing a chart

On Fri, 16 Jan 2026 16:24:13 -0500
Robert Funnell <robert.funnell@mcgill.ca> wrote:

> Dave -
>
> On 2026-01-16 14:48, Dave Howorth wrote:
> > On Fri, 16 Jan 2026 18:35:40 +0000
> > Brian Barker <b.m.barker@btinternet.com> wrote:
> >  
> > > At 18:15 16/01/2026 +0000, you wrote:  
> > > > I have two columns of data:
> > > > $B3:$B3845 shows 'generated' data for each day
> > > > $D3:$D3845 shows 'diverted' data for each day  
> > > …  
> > Perhaps oddly, I'd managed to somehow select the data columns using
> > your second method. It's actually 'the rest' of drawing a chart
> > that I find difficult. :(  
>
> Once you've selected your data, as above, and done Insert > Chart,
> just select XY (Scatter), confirm that Points Only is selected, and
> click on Finish. Does that not give you what you want?

I'm afraid not. I've discovvered what's going on though thanks to your
help. What that gives me is the same as I had before, a vertical line
with a few scattered dots. But thanks to your confirmation that my
process was correct, I guessed that it must be the data that was wrong.

So after inspecting the data and correcting a few errors, I finally
have a graph that looks sensible. Thanks for your help.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy