Re: [libreoffice-users] drawing a chart

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  
>
> Your first problem is that your two data columns are not adjacent. 
> There are two ways to circumvent this:
>
> o The obvious way: Rearrange your columns or simply copy their data 
> into other adjacent columns. If you make these copies active (=B3 and 
> so on), any changes will be carried over.
>
> o Select the two columns *without the intervening column*. To do 
> this, select one column (or cells) and then hold the Ctrl key down 
> whilst selecting the other column or cell range. If you then click 
> the Chart button or use Insert | Chart..., the chart will use the 
> data you have selected.

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. :(

> The rest should be easy.
>
> I trust this helps.
>
> Brian Barker - privately

PLease respond on list.


-- 
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