+ Reply to Thread
Results 1 to 3 of 3

Chart not showing MY dates, ive tried Text and date axis

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    65

    Chart not showing MY dates, ive tried Text and date axis

    Hi

    My attached data, im trying to simply plot the sales with the dates ive got, the dates are all 28 days apart,

    But when i plot, instead of showing 07/12/13 it shows 01/12/13

    When i change it to text, i do not get all the data, it misses the last few periods

    Please advise

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Chart not showing MY dates, ive tried Text and date axis

    I don't know why it isn't honoring the Text Axis. However, you can set it back to automatic and set the major X units to 28 Days.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Chart not showing MY dates, ive tried Text and date axis

    More puzzling. If you convert the data range to an Excel Chart, and build the chart off of it. It comes out just fine.

+ 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. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  2. Chart Axis in terms of Dates/Other Chart Date Questions
    By jp470519 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2014, 06:27 AM
  3. [SOLVED] Pivot Chart Date Axis, need dates seperated proportionally not equally
    By Peter.M in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-18-2013, 09:51 AM
  4. [SOLVED] Dates not showing correctly on x-axis
    By wes675 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2013, 05:55 PM
  5. Duplicate dates showing up in axis chart
    By msmonte111 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2013, 12:15 PM
  6. [SOLVED] Chart showing date and names on a time axis
    By D-smoke in forum Excel Charting & Pivots
    Replies: 24
    Last Post: 10-30-2012, 10:18 AM
  7. Chart, Date/Text Axis Format Question
    By brownj13 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-14-2009, 08:32 AM

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