+ Reply to Thread
Results 1 to 3 of 3

Help with a chart

  1. #1
    Registered User
    Join Date
    07-14-2006
    Posts
    50

    Help with a chart

    Hi all,

    I am looking to do a chart for the following information but I cannot seem to get it working the way i want it too...

    Here is the data I am looking to plot : help.jpg

    And i have done a (ROUGH) drawing of what i want it to look like... : Untitled.jpg

    If someone could advise what chart will work for me, it would be a great help.

    Thank you in advance.

    Emma x

  2. #2
    Registered User
    Join Date
    04-18-2012
    Location
    no
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Help with a chart

    Hey Emma

    Something like this?:
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Help with a chart

    Hi Emma x,

    do you want to sum all the data? Or do you want separate charts for a, b, c, d, and so on? You will need to plot two different series, one for planned and one for actual. The way your data is laid out, this is not easy, but it is easy to re-arrange the data to make it suitable for charting. But before we do that, please clarify if you want to plot the totals or each row.
    Like a post? Click the star below it!

+ 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