On Fri, 16 Jan 2026 18:35:40 +0000 Brian Barker <[email protected]> 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: [email protected] 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
