+ Reply to Thread
Results 1 to 3 of 3

Creating a graph to chart business performance

  1. #1
    Registered User
    Join Date
    05-19-2008
    Posts
    56

    Creating a graph to chart business performance

    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

  2. #2
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Creating a graph to chart business performance

    Yes its possible, refer Creating Charts in 2007 excel help. you could get some more info at http://www.contextures.com/charts.html

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Creating a graph to chart business performance

    Hello,

    yes, that sounds possible with Excel 2003, without VBA but digging in the Excel charting trick box.

    Why don't you upload a set of sample data (anonymized, please) in a workbook and let's work through it. Should be fun.

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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