Can't use ranges with graphs

Discuss the spreadsheet application
Post Reply
Isak
Posts: 2
Joined: Mon May 25, 2020 10:18 pm

Can't use ranges with graphs

Post by Isak »

https://imgur.com/a/brHLb2u
Chart.png
I want to display the data in this graph, but with ranges, So I want the X-Axis to be (80,000-100,0000), (100,000 -120,000)
Last edited by MrProgrammer on Mon May 25, 2020 10:57 pm, edited 1 time in total.
Reason: Attached chart image
FJCC
Moderator
Posts: 9619
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Can't use ranges with graphs

Post by FJCC »

Do you want ranges on the x axis and a count of occurrences on the y axis, so a histogram of the ranges?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
Lupp
Volunteer
Posts: 3755
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Can't use ranges with graphs

Post by Lupp »

Welcome to the forum!

Sorry. I cannot see how your question and the image should be compatible. Did you actually want to get a column chart showing a frequency diagram (about: histogram) for a sample (incomes or so)?

To see what I mean look at this example:
aChart.ods
(24.83 KiB) Downloaded 151 times
(The version you show in your signature is very old. You should consider an upgrade. Current version is AOO V4.1.7.
The colors I assigned by their RGB values in the example will only be shown if the file is opened with a not too old version of LibreOffice. The example was made with LibO V6.4.3.)
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Isak
Posts: 2
Joined: Mon May 25, 2020 10:18 pm

Re: Can't use ranges with graphs

Post by Isak »

Thank You for the quick and helpful response,

The chart you attached is exactly what I wanted to do, except is there a way to do it without the tally column? Just go straight from the data set to a histogram of tallies?
User avatar
Lupp
Volunteer
Posts: 3755
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Can't use ranges with graphs

Post by Lupp »

-1- I didn't suggest to remove your signature.
-2- For what reason do you think your additional question is sensible?
If I get a plausible reply on "-2-" I will try an answer.
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply