+ Reply to Thread
Results 1 to 1 of 1

How to show discrete dates on X-axis

  1. #1
    Registered User
    Join Date
    07-05-2010
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to show discrete dates on X-axis

    Hi All,

    I have a data series where the X-values (dates) are neither continuous nor in equal gap or interval. How can I show only the dates on X-axis for which I have a Y-value?

    Attached file will clear the problem. In the file, the graph shows all the X-values (dates) at equal interval. I want only the dates to be seen for which there is a price point or Y-value, like 1-Jul then 5th Jul, 18th July and so on.

    Can it be done in Excel 2007?

    Awaiting your replies.

    --Warm Regards,
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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