View original (French)

Series of values in a graph that disappear

Z.P. -  
 Anonymous user -
Hello,

I have a problem with charts created from data in an Excel file.
Once the file is saved and closed, when I open it again, some of the data series values have disappeared from the chart, even though they come from a table located on the same sheet.
The values do not contain formulas and the file has no macros, I don’t understand why these values disappear from the selected data for the chart...
I did a test on another sheet by entering data manually and recreating a similar chart, and here the data does not disappear.

My test file is available here: https://www.cjoint.com/c/JKqlmafspCa
In the first sheet, the data series "conso elec chantier NEUF" disappears as soon as I save and close the document... I have to reselect it every time.
In the second sheet, the values remain.

Does anyone have an idea of what is happening and how to fix it?

Thank you and have a nice day

Configuration: Windows / Chrome 86.0.4240.183

1 answer

  1. Anonymous user
     
    Hello,
    What did you use to create this chart? I tried to view it with an old Excel 2000 and then with FreeOffice 2018 and I get the same message:
    "This chart is not available in your version of Excel.
    Modifying this shape or saving this workbook in another file format will irreparably damage the chart."
    What exactly did you do? What data do you want to represent graphically?
    Best regards.
    0