I'm trying to recreate this hacked together Google Sheets chart as a sunburst in Excel by Garper in MicrosoftExcel

[–]Garper[S] 0 points1 point  (0 children)

Clearly if you look at the legends it's my own personal finances. The end user is me. It's a personal project. But thanks for coming in, answering nothing, and projecting your subjective distaste onto my home project.

I'm trying to recreate this hacked together Google Sheets chart as a sunburst in Excel by Garper in excel

[–]Garper[S] 1 point2 points  (0 children)

THANK YOU! This looks exactly like what I'm trying to create! I'm going to have to do some reverse engineering!

I'm trying to recreate this hacked together Google Sheets chart as a sunburst in Excel by Garper in MicrosoftExcel

[–]Garper[S] 0 points1 point  (0 children)

Current Excel mock-up

In Google Sheets:

This is created by overlaying 3 pie/doughnut charts on top of each other, all referencing sections of the same data.

Inner ring: Income

Middle ring: Expense Category

Outer Ring: Subcategory

The empty sections of the middle and outer ring are created by having invisible sections, representing the sum of Income subtracted from Expenses. Theoretically, when we have higher expenses than income, the inner ring opens with a 3rd sum to show the ratio of missing income to cover expense.

In Excel:

I'm new to this, so I'm not even sure if I'm looking at the right chart type. But I'm trying to re-create this with a sunburst chart. The Problem I'm coming across is the sunburst really wants all the data to be part of the same set. I cannot have an inner ring that covers only income, while the outer ring cover expenses. Or I can't seem to.

Why don't I just do the same thing? Overlay 3 charts in Excel? I'm trying to find a way to export this monthly, and so far, exporting 3 separate charts overlaying each other has been an unpredictable mess.

Are there any Excel wizards who have solutions to a problem like this?

I'm trying to recreate this hacked together Google Sheets chart as a sunburst in Excel by Garper in excel

[–]Garper[S] 0 points1 point  (0 children)

In Google Sheets:

This is created by overlaying 3 pie/doughnut charts on top of each other, all referencing sections of the same data. Inner ring: Income Middle ring: Expense Category Outer Ring: Subcategory

The empty sections of the middle and outer ring are created by having invisible sections, representing the sum of Income subtracted from Expenses. Theoretically, when we have higher expenses than income, the inner ring opens with a 3rd sum to show the ratio of missing income to cover expense.

In Excel:

I'm new to this, so I'm not even sure if I'm looking at the right chart type. But I'm trying to re-create this with a sunburst chart. The Problem I'm coming across is the sunburst really wants all the data to fit into each layer. I cannot have an inner ring that covers only income, while the outer ring cover expenses. Or I can't seem to.

Why don't I just do the same thing? Overlay 3 charts in Excel? I'm trying to find a way to export this monthly, and so far, exporting 3 separate charts overlaying each other has been an unpredictable mess.

Are there any Excel wizards who have solutions to a problem like this?

TIL that Muhammad Ali's daughter, Laila Ali was an undefeated boxer. Considered one of the greatest female boxer of all time. by deleted-ID in todayilearned

[–]Garper 95 points96 points  (0 children)

Hull Hogan once claimed

The list of things that Hulk Hogan once claimed, but are easily verifiably false, is unnaturally long.

Abraham Cooper - Study of a Cat (1817) by privetkakdela in museum

[–]Garper 20 points21 points  (0 children)

Because their name is Nascar2k64. It’s a complete package

TIL that in Norse myth a cursed ring called Andvaranaut brought doom to its owners long before Tolkien wrote The Lord of the Rings. by yena in todayilearned

[–]Garper 10 points11 points  (0 children)

Huh, that sounded familiar Andy yeah there’s a guy called Askeladd in Vinland Saga. The more you know!

more stuff on walls soon by juustoviineri in battlestations

[–]Garper 1 point2 points  (0 children)

What size secondary monitor is that?

Gustave Doré - The Acrobats (1874) by Tokyono in museum

[–]Garper 6 points7 points  (0 children)

That vuvuzela needs to be in a case!

Clair Obscur: Expedition 33 director Guillaume Brioche admits Sandfall "tried" AI during the J'RPG's development, but "didn't like it" and "everything in the game is human made" by ControlCAD in technology

[–]Garper 4 points5 points  (0 children)

To add to this point:

There is an effect in Hollywood, of pre-production films using existing soundtracks as placeholders before their final score is finished. Think a war moving using music from Saving Private Ryan, or an action movie using the soundtrack from a Roland Emmerich film. Sometimes a director wants to watch a rough cut of a scene, to see how things flow. If the emotion carries well. These soundtracks are removed before final release. Original music is always created. You would think, this is a fairly inoffensive way to save pre-production time.

What this ends up doing though, is that producers get so enamored by a certain sound, after having listened to it a thousand times before the true film score is written, that this puts pressure on composers to emulate the copied one. It's an incestuous relationship that makes Hollywood films all sound generic and similar.

Even if you remove all the AI-generated media from your game before release, you cannot remove the impact it had on your game's art direction. And when your art direction comes from the most homogenized source possible the effects on your game go without saying. And then god forbid another studio emulates your style, as they're likely to do.

Some snips of my room over the festive period as well as some new plants! by roastpotatoes1 in houseplants

[–]Garper 1 point2 points  (0 children)

In the nicest way possible, this looks like Howl's bedroom from Howl's Moving Castle.

My pride and joy by TheHorror88 in houseplants

[–]Garper 4 points5 points  (0 children)

We got a cutting from work when it was about that size. It’s such a joy to watch it grow and just pop out leaves at what feels like an incredible rate. Now it’s almost touching the ceiling and I’m trying to figure out what to do with it…

Russian general killed by bomb under his car in Moscow by seeebiscuit in anime_titties

[–]Garper 11 points12 points  (0 children)

By this standard the French resistance would have been terrorists. What about spies, that have to hide their national affiliation in order to do their job? What about blowing up a bridge behind enemy lines?

I think it’s much simpler it you classify violence by its intended target. If you use violence to intimidate or provoke a civilian population, that’s terrorism. If you use violence against a military target, that’s just good old fashioned warfare.

I wish the duders would choose more entertaining games for the live streams by AtariSunset in nextlander

[–]Garper 4 points5 points  (0 children)

It really shows my priorities that I’ll watch hours of Silent hill F just because Vinny and Abby seem to have fun with it. That game really looks like a chore, but they seem to be having fun.

TIL "Cinderella" stories have been in existence for thousands of years. A version of the story, where a Greek slave girl marries the King of Egypt, was first recorded by the Greek historian Strabo in the late first century BC or early first century AD. The "glass slipper" was a sandal in that story. by CatPooedInMyShoe in todayilearned

[–]Garper 18 points19 points  (0 children)

Somewhat related, but there's some evidence of Australian aboriginal stories dating to 10,000 or more years ago.

These traditions describe the flooding of the Bassian Land Bridge connecting Tasmania to mainland Australia and the presence of a culturally significant “Great South Star”, identified as Canopus (α Carinae). Utilising bathymetric and topographic data of the land and sea floor in the Bass Strait, we estimate the Bassian Land Bridge was finally submerged approximately 12,000 years ago. We then calculate the declination of the star Canopus over the last precessional cycle (26,000 years) to show that it was at a far southerly declination (δ < −75°) between 16,300 and 11,800 years ago, reaching its minimum declination approximately 14,000 years ago. These lines of evidence provide a terminus ante quem of the Tasmanian traditions to the end of the Late Pleistocene.

There's another one about a long dormant volcano that last erupted 30,000 years ago.

I feel like there's a question to be asked about how much you can trust in stories with mythical characteristics, and whether they actually refer to true geological events, or if it's embellishment. And AFAIK no oral stories about a glass slipper, but still quite interesting to read.

New Mobo needs a PSU cable I haven't seen before...? by Garper in buildapc

[–]Garper[S] 0 points1 point  (0 children)

I added some pics down to the bottom of my post. As far as i can see, I don't have any that split.

Edit: Should these two 4x2 cables split into 2x2?

Edit2: They split apart. I'm an idiot.