Skip to Content
author's profile photo Former Member
Former Member

Changing data between Excel and Xcelsius

I have a Xcelsius 4.5 app that is not displaying data correctly. The app has a combination chart that is connected to a series of cells in an excel spreadsheet. When I connect the combination chart to those cells via that data range and/or series the combination chart displays the data correctly. When I preview the data though I get incorrect data. It subtracts the data in cell 1 from all the other cells. Any ideas what is happening here?

This is what is originall displayed (top row for the columns, bottom row for the line):

first row:

42 52 68 68 68 68 86 97 97 102

second row:

50 67 64 61 58 89 102 102 102 102

But then in preview mode the first value (42) is subtracted from every number and that is displayed instead

first row:

- 10 26 26 26 26 44 55 55 60

second row

8 25 22 19 16 47 60 60 60 60

By the way, the same thing happens when I put the data into a table.

Edited by: bwiegert on Sep 3, 2009 5:17 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 03, 2009 at 04:29 PM

    Welcome to SCN!!

    Can you please share the excel file, you can contact me through my profile..

    -Anil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2009 at 12:20 PM

    Thank you Anil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2009 at 10:28 AM

    Please give some idea about how did you resolve this issue. because i am facing the same issue.in my excel i have 5 tabs(sheets) and it is refering the cells from 0ne sheet to another sheet also.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Anil Bavaraju

      As an aside, I have noticed another thing that might cause this type of behavior is the maximum rows setting. If it is set too low truncation of data occurs. To change this setting go to Data/Maximum Rows... and change the setting. Do not set it too high or it may affect the load time for your app negatively.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.