Thread: [Solved] Chart novice - help required
View Single Post
 
Old 04-12-2012, 07:51 AM
clanger32 clanger32 is offline Windows XP Office 2003
Novice
 
Join Date: Apr 2012
Posts: 2
clanger32 is on a distinguished road
Default Chart novice - help required

Hi All,
I'm really sorry as I'm sure this has been done before, but I'm a bit of a chart novice. I've been tasked by the boss with demonstrating some numbers in a "visually friendly" manner. I know what I want to do, just not how to do it - and I'm hoping someone might be able to help me!

So, the query in question relates to a project I'm working on. The total budget is broken down by a number of categories - so the first thing is to represent a pie chart of that - dead simple, even I can work that.

What is complex, is that I'd like to represent "current spend against category" as a ghost of the parent "slice", if that makes sense. So as a [hopefully!] representative sample, if the there are four categories, A, B, C and D and their respective budget values are 10, 5, 4 and 2, with current spend against each of 4, 4, 2 and 0, what I would LIKE to represent is a pie showing the total value broken down by category (21) with ghost chunks overlaid against their parent chunk [so cat A would have a total size of 10, with an overlaid "4" showing spend against total budget.

I HOPE someone can interpret the fevered workings of my mind and that this can be done - advice very gratefully received!
Reply With Quote