Right-click on the now-selected Chart & choose “Data Ranges”….Right-click on an existing Chart and choose ‘Edit’.In the middle of using the Chart Wizard we get to use the Data Ranges dialog. Thus, in extreme simplified form, the SS looks like this: Date Data1 Data2 First column is headed ‘Date’ and contains formatted dates for each row of data to it’s right.First row contains Headings for the data columns that are below them.

However, I still had to spend a couple of hours trying to decrypt his answer, since I could not make any sense of “It’s getting what it is supposed to show from a range tiitled ‘Lables’ in th rtespective dialog”, so here is an expanded explanation for others as thick as me. Nothing I could do seemed to bring it back until I came across answer on this page. Softw.I was suffering the same problem as the OP for many days after converting a “Columns + Line” chart to a “Stacked Columns + Line” chart when, Hey Presto!, all the formatted dates disappeared from the x-axis of the chart immediately after conversion, being replaced by numbers - the exact problem as the OP (see his CA.ods). P. Schretlen, N. Kronenfeld, D. Gray, J. McGeachie, E. Hall, D. Cheng, N. Covello, W. Wright, in Proceedings of the IEEE VIS (2013)

1(2), 69 (1985)Ī. Inselberg, Parallel Coordinates: Visual Multidimensional Geometry and Its Applications, vol. 20 (Springer Science & Business Media, 2009)ĭ. Ø. Hammer, PAST–Palaeontological Statistics, (University of Oslo, Oslo, Norway, 2020).

Liiv, Statistical analysis and data mining: the ASA. H. Späth, Cluster Analysis Algorithms for Data Reduction and Classification of Objects (Chichester, UK, Ellis Horwood 1980) I. Liiv, Pattern Discovery Using Seriation and Matrix Reordering: A Unified View, Extensions and an Application to Inventory Management (TUT Press Tallinn, 2008) Scott)(Walter de Gruyter, New York, Berlin, 1981) Bertin, Graphics and graphic information processing (translated by W. R. Amar, J. Eagan, J. Stasko, in IEEE Symposium on Information Visualization, 2005. Stasko, Proceedings of the Fifth Workshop on Beyond Time and Errors: Novel Evaluation Methods for Visualization (2014), pp.

Openoffice calc graph x axis labels