Results 1 to 3 of 3

Thread: Charts show wrong result when second workbook is opened

  1. #1

    Charts show wrong result when second workbook is opened



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Situation:
    A single workbook containing charts is opened:
    results look well

    Now when I open a second workbook (alt+tab to folder, double click workbook) , the charts (in both workbooks) suddenly show the wrong results:
    (See attached thumbnails)

    It does not make a change when I select the view side by side option.

    Please, can someone explain why does this happen and how I can fix this?

    Thank you,
    Mark
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	open1.PNG 
Views:	31 
Size:	30.6 KB 
ID:	3718   Click image for larger version. 

Name:	open2.PNG 
Views:	24 
Size:	22.8 KB 
ID:	3719  

  2. #2
    Plot contains trendline which fits the data and is displayed together with equation on the plot

    Hope this helps..

  3. #3
    Additional comment and workaround:
    If I move the excel file that contains the data used for the plots to a subfolder, the graphs won't disposition when I open one or more additional workbooks.

    I can live with that, but still I do not understand why..

Tags for this Thread

Posting Permissions

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