1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: excel unwanted date columns

Discussion in 'Business Applications' started by fredbear99, Feb 24, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. fredbear99

    fredbear99 Thread Starter

    Joined:
    Mar 8, 2011
    Messages:
    9
    I am trting to create a chart using excel. I have inserted dates in column 1 - they are not sequential!. When I put the data into a chart it creates extra dates inbetween those I have actual placed in the cells. Help!
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    63,389
    not a great solution - but format the dates as text - it should then only show the dates you have entered - and should be correct on the chart - but will be a number in the cells

    not sure this is the correct way to go - but it seems to work

    see attached
     

    Attached Files:

  3. fredbear99

    fredbear99 Thread Starter

    Joined:
    Mar 8, 2011
    Messages:
    9
    Thanks etaf you are a genius, its worked
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1042508