#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Hi
you can find lots of info on charts at Jon Peltier's
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Novice having problems with colours. | Simoninparis | Excel Programming | 2 | 02-29-2012 03:28 AM |
What IF statement required | dr4ke | Excel | 8 | 09-01-2011 07:41 AM |
Two questions from a novice | alexB | Word | 0 | 08-11-2010 08:47 AM |
Converting manual chart to bar chart? | aligahk06 | Excel | 0 | 07-03-2010 12:23 PM |
Urgent Help Required | id12345 | Word | 4 | 12-29-2009 08:22 AM |