Graph exclude blank months at end of year
Results 1 to 3 of 3

Thread: Graph exclude blank months at end of year
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2010
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Graph exclude blank months at end of year

    I have a graph of calls for each month. Jan to Dec Along the year, say in June, I'd have blanks for July to Dec.

    I'd like the graph to only show months with data, ie Jan to Jun. and not include empty space for the last 6 months. I've searched and found how to exclude blank dates between data, ie if Feb was 0.


    Thanks,

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Graph exclude blank months at end of year

    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

  3. #3
    Board Regular
    Join Date
    Sep 2010
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Graph exclude blank months at end of year

    I stumbled upon the filter option. I clicked on the graph and on the right was the filter. I clicked on it and I could filter out or uncheck the months (Aug to Dec) I didn't want and those columns did not show up on the graph. Was so simple, I wish I had found that before.

    Thanks

    d

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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