+ Reply to Thread
Results 1 to 5 of 5

Graph display date of saturday and sunday

  1. #1
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    190

    Graph display date of saturday and sunday

    Hi All,
    In the attached sheet, there is data from Mon to Fri. There is also graph for the same but the graph display all the dates whereas i need only dates to be display from Mon to fri ie I don't want 2-May-15,3-May-15 as there is no data for the same to be displayed so please help me.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Graph display date of saturday and sunday

    When I look at the graph I don't see any Saturdays or Sundays listed on the bottom.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    190

    Re: Graph display date of saturday and sunday

    2nd May 2015, 3rd May 2015, 9th May 2015,10th May 2015 so on are saturday and sunday which are shown at the bottom of the graph where dates are

  4. #4
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Graph display date of saturday and sunday

    Try selecting the date labels on the bottom, format axis, and select text axis.

  5. #5
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Graph display date of saturday and sunday

    Thanks for the rep. Glad that was an easy fix to your problem.

+ 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. [SOLVED] Dates in Excel - If Saturday or Sunday, return Friday's date
    By gjrr4x1 in forum Excel General
    Replies: 6
    Last Post: 02-12-2015, 02:56 PM
  2. move date to next Monday if date is on a Friday, Saturday or Sunday
    By ea223 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2014, 01:54 PM
  3. finding date different between two collumn except saturday and sunday
    By sathiyamoorthy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 02:45 AM
  4. How to exculde saturday and sunday in date calculation?
    By Thinker8 in forum Excel General
    Replies: 4
    Last Post: 10-05-2013, 12:26 PM
  5. identifying saturday and sunday in a date
    By mdub72 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2008, 04:23 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