![]() ![]() 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. Please be patient, sometimes it takes a couple of minutes. OPs must reply to the best solution with "Solution Verified" to change the flair to 'Solved' and award the user a ClippyPoint. ![]() You can use this Google Form link to request a shared google sheet be emailed to you that you can use to provide a sample of your issue. Providing a sample of data will make it easier for others to help you. Google's Function List Provide your data! Submissions Submission Guide Wiki Resources Help and support with your functions, formulas, formatting, and Apps Scripts macros in Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |