Results 1 to 8 of 8

Thread: XL Graph

  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XL Graph

    Hello,

    The table in the attached XL file has 3 sets of data.

    I'd like to take the three and have them as 3 sets of bar graphs.

    How can I do that?

    Please can you also do it for me on the XL file & repost that so I can see it as an example?

    Thanks very much.

    BobD.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XL Graph

    This is pretty elementary charting:
    I won't create charts for you but will walk you thru one (it uses the CHART WIZARD). You will learn more doing it yourself.

    Highlight A2:B4
    Insert - chart (or press chart wizard button)
    Choose the Type: BAR chart
    Choose sub type: (Clustered is my guess at what you want?)
    <next>
    <next>
    Click on the tabs and change the options as desired
    <next>
    Choose the chart to be on a chart sheet or embedded object in a sheet
    <finish>

    Do the same after selecting A5:B6 and repeat again for A7:B10

    This is essentially the process for creating all charts, just the options change. I would recommend playing with the options to see what they do.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL Graph

    Dear Steve,

    Sorry for the ambiguity in my question!

    What I am trying to do it get all three sets into 1 single graph.

    And that the MSOffice ones are together.
    Then after a gap the Visio ones are together.
    Then the MSProject.

    But I need all three bunches on one Bar Chart.

    I hope that's more lucid.

    Help!

    BobD.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XL Graph

    Since you want gaps, insert a blank row between MSOffice and Visio, and a blank row between Visio and MS Project. Then use the Chart Wizard to create the chart.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XL Graph

    Select A7 insert - rows
    Select A5 insert - rows
    highlight A2:B10
    Follow directions previously

    Steve

  6. #6
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL Graph

    All I can say is that you guys are Amazing.

    Keep up the good work.

    Thanks,

    Bob.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL Graph

    One way of improving bob's chart would be to colour the bars representing each group differently. The 'format data point' tool enables this.
    But it only allows one data point at a time, and the fprmat painter paintbrush isn't available.
    Is there a simple way of colouring the three bars for versions of MS Office eg yellow, other than individually?

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XL Graph

    Set it up differently. If you make them all separate ranges and use a stack you can have each format different.

    How you set it up depends on what you want it to look like.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •