Results 1 to 8 of 8

How do i recreate this graph

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    How do i recreate this graph

    Ive just realised i have put this in the wrong place. can admin please delete this post or move it to the right area for me. thanks

    Hello all,
    I am looking at creating this graph using my own data but dont know the graph types name in Excel. I have tried lots of different methods but cant seem to recreate it.
    This is how i want it to look.

    http://profile.imageshack.us/user/se...paintgraph.jpg

    so here goes:

    it is a bar graph (bars are green, the "background" is red). the whole thing is the background for a line graph.

    so as the stats are recorded as a line graph, it will show if its within the estimated target (green zone) or not (red zone)

    so numbers are from 180000 - 0
    135,000
    135,000
    100,000
    90000
    79000
    50000
    20000
    0

    with the months along the bottom for the "bar chart" part, with the line going from left to right with figures within the numbers for each month.

    the idea is that the numbers will be reduced as time goes on, so in a perfect world: the line will go down and stay in the green all the way.

    I hope someone can make sense of that,

    Cheers

    Sel
    Last edited by Selwof; 09-09-2009 at 07:31 AM.

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