+ Reply to Thread
Results 1 to 11 of 11

Categorized graph with months

  1. 10-25-2017, 10:42 AM #1
    mmahrous
    mmahrous is offline
    Registered User
    Join Date
    10-25-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    5

    Unhappy Categorized graph with months

    Hi,

    Does anyone know how to achieve this kind of graph? (assuming the x's are numbers of course)

    https://i.stack.imgur.com/B3W3G.png

    Thanks,

    Mike

    Screenshot.png
    Reply With QuoteRegister To Reply
  2. 10-25-2017, 10:47 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    Yes, I do. Please attach a sample file and I will show you how.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-25-2017, 10:55 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    Actually, I have the attached example - I hope it will help you to work out how to set the data series.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-25-2017, 11:00 AM #4
    mmahrous
    mmahrous is offline
    Registered User
    Join Date
    10-25-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Categorized graph with months

    Thank you. I just attached it
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 10-25-2017, 11:02 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    Have a look at my example and see if you can apply it to your own data. Just shout if you need any help.
    Reply With QuoteRegister To Reply
  6. 10-25-2017, 11:13 AM #6
    mmahrous
    mmahrous is offline
    Registered User
    Join Date
    10-25-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Categorized graph with months

    Thank you. Is there any way i can keep it to two bars only? For example I wanted to view the impacted and total exposures beside each other
    Reply With QuoteRegister To Reply
  7. 10-25-2017, 11:15 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    Just deselect the series you don't wish to include: right click on the graph - select data - tick boxes as required.
    Reply With QuoteRegister To Reply
  8. 10-25-2017, 11:45 AM #8
    mmahrous
    mmahrous is offline
    Registered User
    Join Date
    10-25-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Categorized graph with months

    Thank you! I definitely learned a useful trick today. Although here's what I came up with and it's a lot of bars with many colours. Is there a way I can figure out how to get to the result like the screenshot I attached in the beginning?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 10-25-2017, 11:51 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    You could change the chart type to stacked column.
    Reply With QuoteRegister To Reply
  10. 10-25-2017, 11:57 AM #10
    mmahrous
    mmahrous is offline
    Registered User
    Join Date
    10-25-2017
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Categorized graph with months

    well thanks a lot for your help, sorry for being too demanding . Unfortunately it has to be two bars per system category(impacted and total)..
    Reply With QuoteRegister To Reply
  11. 10-25-2017, 11:59 AM #11
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,836

    Re: Categorized graph with months

    You are not being too demanding, but I am afraid I have run out of time for today (I'm in a different time zone!), so hopefully someone else will take it from here. Good luck!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I want to create a graph using months...
    By sarahhllmn in forum Excel General
    Replies: 3
    Last Post: 04-20-2016, 09:07 PM
  2. Graph not showing months ?
    By dougers1 in forum Excel General
    Replies: 1
    Last Post: 11-01-2015, 07:06 AM
  3. [SOLVED] Graph Will Not Show Additional Months Data?
    By garrett.grillo in forum Excel General
    Replies: 8
    Last Post: 03-26-2014, 01:25 AM
  4. 18 months rolling on the same graph
    By bigern87 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-02-2012, 05:47 AM
  5. Help needed to link graph and months together
    By kyodo in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-20-2012, 06:48 PM
  6. [SOLVED] X-Y Graph with Months, Not Date on Axis
    By Sam Fertel in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 12:20 AM
  7. [SOLVED] Graph Help- 12 month graph, but only want months that have passed
    By coal_miner in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-03-2005, 11:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1