+ Reply to Thread
Results 1 to 10 of 10

Help with a simple Bar chart (somewhat urgent for today)

  1. #1
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Help with a simple Bar chart (somewhat urgent for today)

    Hi all,

    long story short: my sister is moving to England and she wants to send a major section of her thesis in before she does. We're trying to figure out how to make a bar chart showing total # of artefacts (Column B) on the Y axis by "Phase" (column C) on the X axis

    We need these for the tabs in the attached sheet. I tried to do this is Sheet1 but failed =\

    Can anyone help. She flies out tonight and this is the last bit.

    Thanks!


    Jay

    (gah, the attachment box won't work - i'll try on another browser) - edit: nope, no joy. i uploaded it to dropbox here
    Last edited by canadianjameson; 05-04-2018 at 03:22 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,694

    Re: Help with a simple Bar chart (somewhat urgent for today)

    The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Help with a simple Bar chart (somewhat urgent for today)

    I see your wizarding ways! =)

    See attached. Also, the title of the graph should be "Pipes recovered by Phase" (for the pipes tab - change for other if possible)

    Thanks so much! Sorry for the urgency
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Help with a simple Bar chart (somewhat urgent for today)

    With helper cells:
    Tab names in A2:A5
    Counts by phase in B2:I5 using:
    Please Login or Register  to view this content.
    Unidentified:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Help with a simple Bar chart (somewhat urgent for today)

    Hey! Sorry for the delay!

    We sent this to her supervisor and I'll see if they request modifications. If so I'll post back, if not thanks so much!

    Cheers,


    Jay

  6. #6
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Help with a simple Bar chart (somewhat urgent for today)

    Hi again!

    So her thesis supervisor got back to her and requested the following adjustments:
    • Given that the different types of artefacts are discussed in different sections of the thesis each type of artefact needs its own graph (pipes by phase, glass by phase, etc)
    • We don't need the coins graphs at all (not a major part of thesis
    • He wanted the axes reversed, so Y = number of artefacts and X = different phases

    Is this hard to do? I know it's stupid but i wasn't able to switch the axes when i tried before =\

    Thanks,


    Jay

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,531

    Re: Help with a simple Bar chart (somewhat urgent for today)

    If I understand correctly you want to use column graphs as shown in the attached file.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  8. #8
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Help with a simple Bar chart (somewhat urgent for today)

    Thanks so much for your help - I have sent it on to my sister but i think it's perfect.

    Thanks,


    Jay

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,531

    Re: Help with a simple Bar chart (somewhat urgent for today)

    You're Welcome and thank you for the feedback. If this resolves the issue please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you and your sister have a blessed day.

  10. #10
    Registered User
    Join Date
    04-02-2010
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Help with a simple Bar chart (somewhat urgent for today)

    Hi - she loved it; thanks so much!

    Will do right away - have a wonderful day, as well!

    Cheers,


    Jay

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Urgent - Need simple formula for counting number of cells between value
    By jackblack2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2018, 12:15 PM
  2. Very urgent - need help with formulating 2 simple counting formulas
    By jackblack2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2017, 08:44 AM
  3. [SOLVED] URGENT - how do you do simple sums with cells set to date format
    By Muzza86 in forum Excel General
    Replies: 8
    Last Post: 06-25-2014, 07:03 AM
  4. Requesting a simple counting function, pretty urgent (VBA)
    By ssdt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2008, 08:47 PM
  5. Urgent help required, deadline 18.00 today
    By khalid79m in forum Excel General
    Replies: 2
    Last Post: 12-27-2006, 01:19 PM
  6. Simple Question but need urgent help pls...
    By hendnov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2006, 09:15 AM
  7. Urgent simple formula help
    By pinehead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2006, 06:10 PM

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