Problem with non-contiguous Bargraph data

[Genesis1]

I have no problem making a bar graph when the columns are contiguous. A-Months, B-Income, C-Expenses, D-Assets. The month names are on the X-axis bottom, a currency scale is y-axis on left and i get 3 colour-coded bars for each month.

But when they are spread out on a much larger spreadsheet, problems.
A4-A15 months
K4-K15 income
K34-K45 expenses
B55-B66 assets
When I Ctl-SELECT the 4 areas, the bar graph created is screwed up.
I get a garbled characters on x-axis. Just Column A in Legend and 3 set of columns with 4, 5, and 5 bars in them. Those are the number of months with data.The 1st set with 4 column is Assets. The next two are Income and Expenses. The Create Bargraph wizard is reading columns in wrong order. Not left to right at least. See screen snip.

[Genesis1]

here is how is should be. imgur image

[anon73440385]

Hello,

you can’t use the chart wizard the default way, if you got non-contiguous data. You need to explicitly tell which data are data and which column is to be used for the category. To do so:

• Do not select anything in advance
• Insert -> Chart and select chart type Column
• Click button Next
• Click button Next (yes leave Data Range for now)
• [Start] Click button Add to add a Data Series ( “Series” appears in the panel labelled Data Series)
• Select/Click on “Series” and “Y-Values” in right pane
• Select the series 1 (e.g K4:K15) using the icon rightmost
• Select “Categories” and select range A4:A15 again using the icon rightmost
• Optional Select/Click on “Name” in right pane
• Optional Select “Range for Name” and select a cell containg a Name (i.e “Income” for Data Series)
• [End] Repeat from [Start] for the other two ranges (i.e K34:K45 (Expenses) and B55:B66 (Assets)

Finally you have:

See also the following sample file: Chart-NonContiguousRanges.ods

Tested using LibreOffice

Version: 7.0.4.2, Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded

Hope that helps.

[Genesis1]

Yes the only problems i had was getting back into editing mode after hitting return I had to delete the bargraph 3 times due to that But finally i made an error free configuration. Thank you very much for your tutorial How do i indicate your answer
was the answer?

[anon73440385]

How do i indicate your answer was the answer?

click the check mark () next to the answer

[Genesis1]

thank you again