+ Reply to Thread
Results 1 to 1 of 1

Help with modifying budget templates: charts, sparkline, and linked tabs

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    San Diego, CA
    MS-Off Ver
    MS Office 365
    Posts
    1

    Help with modifying budget templates: charts, sparkline, and linked tabs

    Hi there. I'm not very Excel savvy, and I'm trying to modify a preexisting excel budget template to better represent my expenses. I've attached the workbook, which should help clarify exactly what I'm talking about.

    My primary concern is that I can't figure out how to have my charts at the top of the "Money Tracker" tab change to reflect the month I'm viewing (using the slider). I broke this function when I heavily modified the tables. Can someone provide details on how to fix this?

    Secondly, I'm not sure how the Sparklines work, but I do like this feature of the template. It's very visually appealing, and gives me a good at-a-glance idea of the history of my expenses. How can I fix these so they capture data from every month?

    Finally, is it possible to link the data between the tabs? For instance, I'd like to record my categorized expenses/income only on the "Budget Planner" tab each month, and have it auto-fill to the "Money Tracker" and "Budget History" tabs for the correct month. However, I don't want them to be permanently linked, because I'll be wiping that first tab at the start of each new month and filling in new information (the historical data will be stored on that third tab.) Is this possible? I don't mind altering the formula each month, as long as I know how.

    In advance, THANK YOU for reading and EXTRA THANK YOU to anyone who replies.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2013, 06:36 AM
  2. [SOLVED] Budget Meter without using charts.
    By hanzechin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2013, 03:23 PM
  3. Creating Multiple charts from templates
    By jhelliar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2011, 08:17 AM
  4. Modifying linked tables in Access
    By Talat in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2010, 08:21 AM
  5. [SOLVED] Budget templates
    By Therese in forum Excel General
    Replies: 0
    Last Post: 01-19-2006, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1