Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart Type Changes (Excel 2003 SP2)

    When putting in a certain date range like in the past this user's chart changes from a Stack column chart to a line chart and the user doesn't want this to change.
    She has other documents that she does the exact same way and she doesn't have this problem.

    Anyone know if Excel stores chart info in a separate template or other file that might be corrupt?

    Client recreated this file and chart a while ago when this happened and would like to avoid this and discover what might be happening.

    Thanks,

    Jester
    I know enough to know I don't know enough

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart Type Changes (Excel 2003 SP2)

    Let her try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Type Changes (Excel 2003 SP2)

    Thanks. I have been using the Word article and totally neglected to check for this.

    -Jester
    I know enough to know I don't know enough

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Type Changes (Excel 2003 SP2)

    What I have learned is the file with the chart was in use for about 6 months after being recreated for the same issue. Anyone who opens this file and edits the chart encounters the same issue: the Stack column chart switches to a line chart. Whatever causes this behavior, even if it was introduced by one user's Excel, is stored with the file or wherever the chart info is stored.

    This is the only file exhibiting the behavior and the original file was in use for 2 years prior to this behavior showing up at the beginning of the year. At that time the file was recreated and now has gone 6 months until acting up again.

    I have suggested that prior to recreating the file, anyone accessing it run the Excel /o startup command but I'd rather have the department limit their once a month usage of the file to one machine and see if they can pinpoint how this scenario is being introduced to the file.

    -Jester
    I know enough to know I don't know enough

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Type Changes (Excel 2003 SP2)

    If you like, you could attach a stripped down version of the file that shows the problem along with the steps to repro it, that way we can try to troubleshoot.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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