Good afternnoon, intermediate excel user but not too au fait with graphs. I have the following values I need to chart:
(A) Target (the figure that the section of the business needs to meet)
(B) Tolerance (a 5-10% figure allowed past the target)
(C) Result (the actual achieved figure)
(D) Benchmarking maximum (the highest of a dozen or so businesses we can compare to)
(E) Benchmarking minimum (lowest of a dozen or so businesses we can compare to)
I want to make over 40 of these. For each one, the values A-E will be of the same type (% or days or hours etc).
What I want for each is the following:
1.A bar to represent (C) (easy enough).
2.A line to represent (A) with the whole area below it (except the bar for C) to be shaded red/green, dependant on whether I'm trying to get above/below that target (this can be worked out by seeing if the tolerance is higher or lower than the target).
3.A line to represent the tolerance, with everything in between it and the target shaded amber
4.Everything above/below the tolerance (depending on the line in '2' above) shaded red
5.A point on the far left for benchmarking max and a point on the far right for benchmarking min, with a line connecting them.
Is this something that can be done in Excel charts (I'm running Excel 03 but can get on a maching with 2007 if that's better), without having to perform vba?
Thanks in advance
Bookmarks