+ Post New Thread
Results 1 to 10 of 10
How do you do....it? Thread, Excel problem in Technical; Hi Peeps, I am pulling my hair out here so help would be gratefully received. I am using Excel 2010 ...
  1. #1

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    978
    Thank Post
    68
    Thanked 129 Times in 92 Posts
    Rep Power
    125

    Excel problem

    Hi Peeps,

    I am pulling my hair out here so help would be gratefully received.
    I am using Excel 2010 and creating a bar chart but the date range keeps defaulting to 1900 to 2168 or thereabouts.

    I have checked the cell with the dates in and formatted them to date format but it doesn't help.

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    Can you upload a sample of the data?

  3. #3

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    978
    Thank Post
    68
    Thanked 129 Times in 92 Posts
    Rep Power
    125
    Here it is, I have tried this in two versions of Excel and it does it in both, probably my fault then!
    Attached Files Attached Files

  4. #4

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    What are you trying to show in your chart?

  5. #5

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169

  6. #6

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    978
    Thank Post
    68
    Thanked 129 Times in 92 Posts
    Rep Power
    125
    I want the data for the duration showing only, I can remove the start bar by hiding them but can't stop the data range from being so long. I have also tried setting the date range for the axis but it doesn't work.

  7. #7

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    Is this the sort of thing?
    gannt.jpg

  8. #8

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    978
    Thank Post
    68
    Thanked 129 Times in 92 Posts
    Rep Power
    125
    Yes, that sort of thing, I am trying again in Office 2003 as it is less fiddly. Just got to the point where I select the duration in the series tab and it screws up the date again!

  9. #9

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    Have a look at this (I am using 2003)
    Attached Files Attached Files

  10. Thanks to CESIL from:

    NikChillin (14th February 2011)

  11. #10

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    978
    Thank Post
    68
    Thanked 129 Times in 92 Posts
    Rep Power
    125
    Ah, I see what you have done. Gives the required data though doesn't it.
    Thanks



SHARE:
+ Post New Thread

Similar Threads

  1. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 05:55 PM
  2. excel adding problem
    By browolf in forum Office Software
    Replies: 13
    Last Post: 11th June 2010, 10:22 AM
  3. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 12:23 PM
  4. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 11:08 PM
  5. Bizzare Excel Problem
    By Norphy in forum Windows
    Replies: 3
    Last Post: 17th January 2006, 11:19 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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