Why does the data turn red?

[hans0504Participant]

I copied two rows of data from an Excel sheet and converted them into the form of number, but the data turned red.

[kirktParticipant]

<p style=”text-align: right;”>Probably the comma delimiter for the decimal.</p>
I am not at a computer, but check preferences to see if data graph is configured to use commas as the decimal delimiter.

kirk

[dgteamModerator]

DataGraph stores data in the table with the point as the decimal, so that is the issue.

You can use Data > Find and Replace to fix OR instead of a using Edit > Paste use Edit > Paste Special.  Then you can change on import.

To see an example with Paste Special, check out the page on Data Input.

Note that you can format the data axes to use the comma as the decimal separator for your graphs or labels.

[Author]

Posts