How to Create a Bar Chart?

https://preview.redd.it/yykqb6iaeeue1.png?width=1854&format=png&auto=webp&s=bc109f587ee841971e5a03531680c51f3656c8ad

ORIGINAL POST

Hello. I'm using the latest version of libre office on Ubuntu.

I would like to make a classic bar chart but I can't. I've looked at some tutorials and I can't get my data to display. I've looked at some tutorials and I can't get my data to display. I've checked that the format of my cells is correct, but I still have the same problem. Can anyone help me? THANK YOU

I need to make a graph like this:

https://preview.redd.it/hj49pysteeue1.png?width=1016&format=png&auto=webp&s=daa191c0b5971a556b1b6522eaf883682fe7beb0

2 replies

AutoModerator · 5 months ago

If you're asking for help with LibreOffice, please make sure your post includes lots of information that could be relevant, such as:

Full LibreOffice information from Help > About LibreOffice (it has a copy button).
Format of the document (.odt, .docx, .xlsx, ...).
A link to the document itself, or part of it, if you can share it.
Anything else that may be relevant.

(You can edit your post or put it in a comment.)

This information helps others to help you.

Thank you :-)

Important: If your post doesn't have enough info, it will eventually be removed (to stop this subreddit from filling with posts that can't be answered).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1 upvotes on reddit

Tex2002ans · 5 months ago

> Trouble making a bar graph (self.libreoffice) > > I would like to make a classic bar chart but I can't.

Well, the most common problem is data accidentally set as TEXT.

To fix that, you need to:

Left-Click to highlight your numbers.
Right-Click > Format Cells

and actually set them as NUMBER.

> I've checked that the format of my cells is correct, but I still have the same problem.

Hmmm... so, the second most common problem is still text, but it's this hidden "apostrophe" before numbers.

If you:

Click on one cell... like C2.
Look in the formula bar.

Do you see:

='1000.0
- See that APOSTROPHE before the number?

If you do, then you'll have to clean the data:

Data > Text to Columns

For more details on why that happens, see:

/r/LibreOffice: "Calc, Why does it add ' character at copy paste?"

Once you get your actual number cells marked as NUMBERs/CURRENCY, the bar charts should create themselves. :)

Side Note: Also, if you want a legend, you can select:

B1:B6 and E1:E6
- Including the "Process" and "Total Result" labels.

Right now, in your screenshot, you accidentally selected just the raw data:

B2 and below + E2 and below.

If you select everything, label and all, the Insert > Chart wizard can also help pre-fill in some of that extra info for you.

> THANK YOU

You're welcome. :)

1 upvotes on reddit

See 2 replies

r/unity_tutorials • [2]

Summarize

Create a Graph: Bar Chart (Unity Tutorial in Comments)

Posted by UnityCodeMonkey · in r/unity_tutorials · 7 years ago

9 upvotes on reddit

2 replies

Helpful

Not helpful

2 replies

pleximind · 7 years ago

I don't know how I'm going to use this, but I definitely will.

3 upvotes on reddit

UnityCodeMonkey · OP · 7 years ago

Check out the tutorial video: https://youtu.be/hy4IID--Ue0

Continuing to create a graph in Unity we're going to display our graph as a Bar Chart.

If you have any questions post them in the comments and I'll do my best to answer them.

Cheers!

2 upvotes on reddit

See 2 replies

r/PowerBI • [3]

Summarize

Creating bar chart of multiple locations

Posted by Garden-Gnome1732 · in r/PowerBI · 1 year ago

This is a very elementary question but I work at nonprofit and have no one to ask. I've tried googling and I'm still unclear on the answer.

I have a table with 18 locations. The first column is the name of all locations. The subsequent columns are titled "Month Year" and I have a year's worth of columns. Under each column, I have the number of applications each location completed.

I want to create a bar chart with the locations on the x-axis and the applications on the y-axis. I did complete it, however each month is kinda separated by a thin white line, which is bothering me. My issue is I cannot create a slicer to look at the months individually. Each month is a field, so I can only add one month as a on the slicer. I tried switching the columns with rows and then the visual isn't doing what I want.

I ~~think~~ the issue is how i have the data presented but I'm not sure how to fix it. Please advise, thanks.

1 upvotes on reddit

4 replies

Helpful

Not helpful

4 replies

_T0MA · 1 year ago

You need to unpivot your table. So instead of wide table you will have long table. That way you will have MonthYear in same column. You will have 3 columns in total. LocationName, MonthYear, Value.

4 upvotes on reddit

Garden-Gnome1732 · OP · 1 year ago

Thank you! It worked perfectly. I really appreciate it!

2 upvotes on reddit

itsnotaboutthecell · 1 year ago

!modthanks

1 upvotes on reddit

reputatorbot · 1 year ago

You have awarded 1 point to _T0MA.

^(I am a bot - please contact the mods with any questions)

1 upvotes on reddit

See 4 replies

r/androiddev • [4]

Summarize

How to create bar chart from scratch?

Posted by sanjaydgreatest · in r/androiddev · 4 years ago

I'm an entry level android developer, and I've took up a project to create a bar chart from scratch.

How should I go about doing it? A brief roadmap would really be helpful, because I'm mostly blank right now.

PS - I think most probably I'll be working with custom drawing classes like Canvas/Paint, so I've already started learning them.

2 upvotes on reddit

3 replies

Helpful

Not helpful

3 replies

miaurycy1 · 4 years ago

Creating custom views like a chart is not what you should start learning with. To be honest, most of the time we're using libraries that provide ui components. We just customize things and rarely write everything from scratch. You should first focus on other things like design patterns, core libraries, async code, ui components and Android API in general. Look at this library https://github.com/PhilJay/MPAndroidChart it should be pretty good. Of course if creating views from scratch is your goal then ok, I'm just talking about everyday developer job.

3 upvotes on reddit

sanjaydgreatest · OP · 4 years ago

Yeah definitely agreed.

But creating a bar chart from scratch is one of my goals right now.

3 upvotes on reddit

[deleted] · 4 years ago

Wrong sub. Try /r/learnprogramming for help with algorithms for things like that.

-6 upvotes on reddit

See 3 replies

r/Unity2D • [5]

Summarize

Create a Graph: Bar Chart (Unity Tutorial in Comments)

Posted by UnityCodeMonkey · in r/Unity2D · 7 years ago

8 upvotes on reddit

1 replies

Helpful

Not helpful

1 replies

UnityCodeMonkey · OP · 7 years ago

Check out the tutorial video: https://youtu.be/hy4IID--Ue0

Continuing to create a graph in Unity we're going to display our graph as a Bar Chart.

If you have any questions post them in the comments and I'll do my best to answer them.

Cheers!

2 upvotes on reddit

See 1 replies

r/Unity2D • [6]

Summarize

Create a Graph: Bar Chart Visual Object (Unity Tutorial in Comments)

Posted by UnityCodeMonkey · in r/Unity2D · 6 years ago

2 upvotes on reddit

2 replies

Helpful

Not helpful

2 replies

gifv-bot · 6 years ago

GIFV link

^I ^am ^a ^bot. ^FAQ ^// ^code

1 upvotes on reddit

UnityCodeMonkey · OP · 6 years ago

Check out the tutorial video: https://youtu.be/QmU57Ka9H0E

Continuing the series let's create an Interface so we can later update our Graph with ease.

If you have any questions post them in the comments and I'll do my best to answer them.

Cheers!

1 upvotes on reddit

See 2 replies

r/AppleNumbers • [7]

Summarize

Complete noob please help me create this.

Posted by FFshorty_19 · in r/AppleNumbers · 19 days ago

Hello everyone I am trying to be more intentional with my finances and I’m working on a spreadsheet.

I have looked at YouTube and googled how to and I can’t seem to find what I’m looking for.

I created a table where I’m putting all my transactions and made a drop down menu with different categories.

Basically what I’m trying to do is make a bar graph that has the total, but every time I add a transaction for that category I want the bar graph to pick it up and subtract that amount.

For example: Bar graph of my wife’s “fun” money at $500. She gets her nails done for $80 and inputs that amount on the table and uses the category “personal” from drop menu. Then bam the bar graph drops from $500 to $420.

Would like to do the same thing with like a pie chart and track spending in other categories as well.

Is that possible? How do I do it? Please help.

3 upvotes on reddit

4 replies

Helpful

Not helpful

https://youtu.be/fAf8dRgQayY

4 replies

Tom_Jack_Attack · 19 days ago

Have you tried the inbuilt home budget template? It might be easier to start with that and modify it to suit. At least all the formulas are already there.

2 upvotes on reddit

FFshorty_19 · OP · 19 days ago

No I haven’t. I decided to go blank and add what I want to it. Might take a look.

1 upvotes on reddit

ZirikoRuiGe · 19 days ago

If you are a noob, I would highly suggest going with the provided template or look for other's templates online. I made a cool one here, but it's a bit more than what you are asking for, but it may give you an idea of what you want to build your finance planner up to.

2 upvotes on reddit

CygnusSouth · 19 days ago

Not sure if this will help as I can’t see your actual setup, but it sounds like you might need to make another table that has the live totals for each category. Then you can draft the bar graph from that table. Formulas are largely universal across numbers, excel, google sheets etc. So you can find a video on how to do this in excel and then translate it across to numbers easily.

1 upvotes on reddit

See 4 replies

r/BlackboxAI_ • [8]

Summarize

Built an awesome full-featured Bar/Pie Chart Generator using just one HTML file and Chart.js

Posted by Fabulous_Bluebird931 · in r/BlackboxAI_ · 3 months ago

Wanted a tool where I could paste raw Label,Value data and instantly get a beautiful, downloadable chart (bar or pie) with theming, no setup, no libraries to install.

So I typed something like this into blackbox-

> “Make a chart generator in one HTML file using Chart.js CDN. Paste Label,Value data in a textarea, choose between bar or pie chart, select a theme, and render the chart with a title. Include a PNG download button. All in one file.”

What it returned… just worked.

You can paste in your data like:

Electricity Usage,5800 Transport (Fuel),3200 Business Travel (Air),1400 Packaging,1100 Waste Management,700 Heating/Cooling,2600 Supply Chain Logistics,3100 Employee Commuting,900

Pick Bar or Pie

Choose from 5 color themes

Add custom title

Download chart as PNG

No npm, no build process, just HTML + Chart.js CDN

I've deployed it here: https://yotools.free.nf/chart-generator.html

This is part of a series I’m doing: “Useful tools Blackbox can code in one go.” Already made a JSON viewer, word definer, markdown previewer and many more (many of them can be found in the above website) all in one file. More coming.

What did you build? and what should I build next?

v.redd.it

2 upvotes on reddit

5 replies

Helpful

Not helpful

5 replies

Secure_Candidate_221 · 3 months ago

this looks great

2 upvotes on reddit

AutoModerator · 3 months ago

Thankyou for posting in r/BlackboxAI_!

Please remember to follow all subreddit rules. Here are some key reminders:

Be Respectful
No spam posts/comments
No misinformation

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1 upvotes on reddit

NoPressure__ · 3 months ago

Woah. This is cool!

3 upvotes on reddit

JestonT · 3 months ago

This is awesome! Great work!

2 upvotes on reddit

shopnoakash2706 · 3 months ago

Nice work, works great.

1 upvotes on reddit

See 5 replies

r/Rlanguage • [9]

Summarize

Ggplot - Stacked Bar Chart by Type

Posted by Afmm18_ · in r/Rlanguage · 1 month ago

I recently started using R and I'm finding it difficult to create a bar chart that has several bars in a row.

As an example, I created this table with random data, but imagine that for the month of January there would be 4 bars each representing ABCD, and so on. How do I do this in ggplot by importing data from Excel?

i.redd.it

4 upvotes on reddit

3 replies

Helpful

Not helpful

3 replies

PositiveBid9838 · 1 month ago

df |> tidyr::pivot_longer(A:D) |> ggplot(aes(meses, value, fill = name)) + geom_col(position = “dodge”)

5 upvotes on reddit

Quantsel · 1 month ago

Yes, just ask ChatGPT and describe your dataframe as part of the prompt.

-5 upvotes on reddit

Thiseffingguy2 · 1 month ago

What have you tried? Please share your code.

If you’re using ggplot, you need to get comfortable with the idea of “tidy data”. Take a look through R for Data Science (https://r4ds.hadley.nz). It should have everything you need. You’ll need to use pivot_longer with that table, so keep an eye out for that section.

6 upvotes on reddit

See 3 replies

r/PowerBI • [10]

Summarize

What is the best way to have a bar chart include a bar for total?

Posted by inslipid531 · in r/PowerBI · 1 month ago

For example my dataset has a column for Category and a column for Subcategory. I would like the bar chart to display the subcategories AND the category they belong to on the axis of one chart.

The way i have gotten around this in the past is is by creating a secondary disconnected table that combines the category and subcategories in one column. But then if i want to replicate that with subcategory and the segments that fall within, i need to create yet another disconnected table.

Surely there is a better way to achieve this?

3 upvotes on reddit

6 replies

Helpful

Not helpful

6 replies

Brighter_rocks · 1 month ago

native bar/column charts can’t show a parent total as just another bar out-of-the-box. you need a tiny semantic trick: build a reusable “axis” table that contains all subcats plus a synthetic “Total” member per category, and a measure that knows when to aggregate the whole parent. no more one-off disconnected tables per view - make one generic axis.

6 upvotes on reddit

Nick-Lee-PW · 1 month ago

I use disconnected tables regularly. they're extremely low-weight in the model and have a lot of flexibility. What do you mean by an "axis" table instead?

1 upvotes on reddit

Brighter_rocks · 1 month ago

yeah it is a disconnected table - just not one-off per chart. think of it as a reusable axis table: holds all subcats plus a synthetic “Total” row per parent, with a flag. your measure uses treatas + that flag to know whether to pull a single subcat or roll up the whole parent. way cleaner than spawning a helper table every time

1 upvotes on reddit

inslipid531 · OP · 1 month ago

Is this not the same as what i mentioned in my original post? Do you mind expanding? Thank you

1 upvotes on reddit

Brighter_rocks · 1 month ago

basically same principle, yep. the twist is: instead of building a tiny helper table for each visual, you build one generic axis table once, and re-use it across visuals. less clutter in the model, easier maintenance.

1 upvotes on reddit

AutoModerator · 1 month ago

After your question has been solved /u/inslipid531, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1 upvotes on reddit

See 6 replies

Top People to Talk to

These are some of the top contributors related to

libreoffice

unity_tutorials

PowerBI

4+ others

AutoModerator

No bio available

2000

Karma

10000

Posts

10000

Comments

Tex2002ans

No bio available

1405

Karma

Posts

2852

Comments

pleximind

No bio available

20466

Karma

Posts

840

Comments

_T0MA

No bio available

1488

Karma

Posts

2849

Comments

miaurycy1

No bio available

523

Karma

Posts

158

Comments

gifv-bot

No bio available

6283184

Karma

Posts

10000

Comments

Tom_Jack_Attack

No bio available

13469

Karma

Posts

3008

Comments

ZirikoRuiGe

No bio available

6858

Karma

189

Posts

1867

Comments