Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XL97 Chart in XL2000 (2000)

    I have a two part question on a WB containing charts originally created in XL97.
    a) The chart contains three lines using weekly data and a line using monthly data. The chart used to display the data is a scatterplot with connected lines. I open the file with no problems in 97 but when I use 2000 (I have had to keep copies of both versions just to open this file) the chart does not display anything in the time axis. What is going on and how fix it?
    [img]/forums/images/smilies/cool.gif[/img] The plot area changes shape (i.e gets really small or large) whenever the data the chart links to changes or when I do a print preview, or print. Any ideas.
    Thanks in advance for any suggestions. I really enjoy many of the ideas I have read in these postings
    Altin Kalo

    ps I have tried to attach the chart. It is linked to external data.
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: XL97 Chart in XL2000 (2000)

    Altin

    I could duplicate your problem on two different PCs. In XL-2000 all the stuff you said was happeneing.

    But without the data workbook I can't make any changes. Could you make a new chart with the data in the same workbook and send it to the list?

    My version of XL-2000 is 9.0.2720 which is not the latest with all the SRs installed. Try that first and see if one of them will clear the problem

    Did you try a new workbook from scratch? Maybe the workbook has some garbage... Need to clean it.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XL97 Chart in XL2000 (2000)

    Thanks for the reply, Wassim. Attached is the same file but now containing the data source. I do understand when you say that I may have to re-create the file but for now that does not seem to be an option. One, there are several files with over 100 charts and I just don't have the time now to recreate them. Second, I cannot figure out how to create a chart that contains three series of weekly data and one series of monthly data. Any ideas? Any help is appreciated. Thanks.
    Attached Files Attached Files

  4. #4
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Anyone can figure this out!!!

    If you can please take a look at the above postings any give me anopinions I would greatly appreciate it. Thanks.

    Altin

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Anyone can figure this out!!!

    Altin

    You have the X-Axsis labels set to 90' orientation, so I changed that to Automatic and they poped back into place after I made the chart a bit larger. If you really want to have them at 90' you may need to enlarge the chart...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  6. #6
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anyone can figure this out!!!

    Clearly a bug -- change orientation to 88 degrees & it't not bad. 89 degrees & it's teeny! 90 degrees & it's gone! Either use 88 or re-orient it!

  7. #7
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anyone can figure this out!!!

    Fantastic. Thanks. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

Posting Permissions

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