![]() ![]() If the tool is free, why did you make it? I learned that creating two or three graphs and placing them near one another made a kind of "super graph" - together, these graphs clearly communicated the data I wanted to show. While powerful, the existing graphs and charts sometimes aren't flexible enough to show all the data you want or to convey the whole picture. Sometimes you want to visually show data in a graphical format in a spreadsheet. ![]() I think they really elevate the experience.Ĭombining multiple graphs to convey more information I'm really proud of the mini pie charts I'm able to show on the Dashboard. Google's IMAGE function is a huge win in this area because you can use it to add a little color and some surprises to your sheets to make them more enjoyable (not to mention useful). Spreadsheets are notorious for being bland and for being a wall of text. This is a huge win for me, because I wanted to the tool to be easy to understand and approachable for technical and non-technical users. Using some simple front-end skills, it's pretty straightforward to create something that mimics a native web application. I come from a FED/UX background and was surprised at just how flexible the styling and theming tools are. Combining this with date ranges provides another valuable window into the data because you can bound your data by years or months.ĭesigning an interface in Google Sheets is fun I split and slice all kinds of Transactions data using these functions to generate reports and the data on the main Dashboard page. It's amazing what you can do with these two functions. Reflecting back, here are some tricks I've picked up on the way.Ī few screenshots of the current version for reference:īeyond basic function uses and technical knowledge, these are some of the standout things I've learned. Our little community has grown a lot recently and it's been great to help others on their financial journeys. Over time, I ended up creating a spreadsheet and making it available for others to download and use ( ). Discouraged, I decided to try creating a budgeting tool in Sheets with the end goal making something powerful and easy to use (features I thought existing templates severely lacked). I tried various ones and, in the end, none of them were quite what I wanted. About 2 years ago, I was on a mission looking for a new budgeting tool. I've been a heavy user of Google Sheets for a few years now and thought it would be fun to share something I've built with this community. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |