hello,
i'm looking for help...i've been trying to figure out a way to visually represent an annual expense budget by month (and how much is remaining). i have a fixed annual budget but it's broken down by month based on the trended growth/reduction each month. example $10k budget for year, jan is $1,200, feb is $800, mar is $1,000 and so forth. I would like to show on a single graph the overall progress through the year and detail how each month compares to the monthly goal with a allowable overage up to 5%. example, jan budget is $1,200 but we went over by $100, it should just show over but if we went over by $500, then it should show as red (or some way of drawing attention). and if possible, the other direction should draw attention too, if we beat the goal by $500. one more thing, this needs to be done for 2 areas. area 1 has a budget and area 2 has a budget.
i tried searching for ideas but i couldn't find anything that seemed to fit my needs. i looked at the article "Best Charts to Compare Actual Values with Targets – What is your take?" but none of those seemed to be the right thing. thermometer seemed the closest but didn't seem to really tell the story. I also saw the burn down chart but i couldn't figure out how to use it for my needs.
i'm looking for help...i've been trying to figure out a way to visually represent an annual expense budget by month (and how much is remaining). i have a fixed annual budget but it's broken down by month based on the trended growth/reduction each month. example $10k budget for year, jan is $1,200, feb is $800, mar is $1,000 and so forth. I would like to show on a single graph the overall progress through the year and detail how each month compares to the monthly goal with a allowable overage up to 5%. example, jan budget is $1,200 but we went over by $100, it should just show over but if we went over by $500, then it should show as red (or some way of drawing attention). and if possible, the other direction should draw attention too, if we beat the goal by $500. one more thing, this needs to be done for 2 areas. area 1 has a budget and area 2 has a budget.
i tried searching for ideas but i couldn't find anything that seemed to fit my needs. i looked at the article "Best Charts to Compare Actual Values with Targets – What is your take?" but none of those seemed to be the right thing. thermometer seemed the closest but didn't seem to really tell the story. I also saw the burn down chart but i couldn't figure out how to use it for my needs.