Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Graphing problem

    On the attached XLS, I'm trying to use the graph shown, but instead of showing just one month from 0 - 100%, I'm hoping to show six months and therefore six bars per client. This way, it's easy to focus on the client and observe any trends. Is there a way to do this? Thanks
    Attached Files Attached Files

  2. #2
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Thanos,

    See Attached. I selected all the data, Inserted a Stacked Bar Graph, then right clicked on the graph created, clicked on select data and when the dialogue box came up I clicked on Switch Row Column and clicked OK. I think this is what you wanted.

    Regards,
    Maria
    Attached Images Attached Images
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Did you mean like this?
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I apologize for the delay Maria. The second sample file is very close but can the orientation be portrait as opposed to landscape? Thanks, Thanos

  5. #5
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Thanos, mine was the first wopr(1)adjusted.xls. By portrait orientation I assume you want to print it on a normal A4 sheet in portrait? If so, you only need to play around with the column widths to make it fit (in print preview mode). If you are talking about the second version that Rory did, then you will probably need to leave this in landscape as if you tried to fit it on a page in portrait mode it would be too small to read.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Like this?
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Rory,
    Thank you for your help. With respect to the output, is it possible to take the output so that the percentages run along the left hand side while the clients and the months run along the bottom? Thanos

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Yes - just right-click the chart and change the chart type to a stacked column rather than stacked bar.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    FANTASTIC! Thank you! Now because I'm really greedy and and pushing your good naturedness, with respect to the success portion of the bar, is there any way that said columns by client can be in different colors? Such as Client One is blue, Client Two is yellow, etc?

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You can manually format any of the bars to any colour you like. If you need that to be automatic, you would need to alter the data layout so that you can effectively plot different series for each client.
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Ahh, ctrl + click. Thanks rory, please consider this matter closed.

Posting Permissions

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