Show off your Excel etc. graphs

[Green_Tea]

Hey everyone,

I've seen some VERY NEAT graphs on here, and being a great lover of excel sheets and creating all kinds of graphs with my data as well, I figured - maybe some would be interested to share!

Looking forward to some cool graphic presentations!

(Hope I have not missed a similar thread).

[RWTL]

I don't really have any graphs.  Mostly just multiple tabs (multiple, multiple tabs).  I'm interested to see if anyone has anything cool

[lutorm]

I log a bunch of home data (power use, weatherstation, smoker temperature...) but since it's just for my own use I don't really put in much effort to make it look nice.

[rantk81]

https://pasteboard.co/JE1ZeDI.png

[Kem]

Assets / Debt / NW:  https://pasteboard.co/JE2oJ4m.jpg

NetWorth / Fi: https://pasteboard.co/JE4PM3b.jpg

(spelling typo... sorry)

[Tass]

@maizefolk does some great stacked graphs and projections.

[vand]

Here's the time-weighted return I've managed in my main retirement portfolio for the last 3 years:



I've managed to compound at 17% annually. This is pretty good and has managed to beat the S&P, but much more importantly I've managed to do it with lower volatility.

The annualised Sharpe Ratio is 0.9 for the Portfolio over this time vs 0.6 for the S&P.. not bad considering the huge volatility we saw earlier this year.


Here's the actual dollar (well, GBP) amount, showing the amount total amount of the portfolio vs the book cost as monthly cashflows have gone in:

[Chaplin]

I'm fortunate to have years of data (and fortunate in many other ways). I had charted my net worth, but started to wonder what had contributed to the increases and it turned out that had the data to figure that out.

So, this graph is not net worth, it's change in net worth. Definitely a humblebrag, but it's the most interesting chart/graph I have.

[Sugaree]

This is my dashboard.  Each of the boxes links to a different tab.

[By the River]

This is my dashboard.  Each of the boxes links to a different tab.

Nice!  I see what I will be working on during slow periods at work.

[WSUCoug1994]

This is my dashboard.  Each of the boxes links to a different tab.

That is some next level dashboarding right there.  I have all of the data (obsessed and recognize I have a problem) but haven't spent much time on visualizations like this.  I need to step up.

[stylesjl]

Very cool graphs, makes mine look rather crude in comparison as you can see in the attachment.

But it does give me an overview of how I'm doing anyway.

[marty998]

This is my dashboard.  Each of the boxes links to a different tab.

THis is quite extraordinary @Sugaree, awesome stuff

[marty998]

I will pop two up here of my own.

My summary balance sheet, and historical net worth tracker. Basic stuff.

Have a few more charts but they've got somewhat more identifying info on them, so we'll keep them to myself :)

[Tass]

I like this very big-picture view of what I'm doing with the money I earn each year.