Charts of data are all zero
Charts of data are all zero
(OP)
A set of data (numbers) I've been given won't show as a chart of that data. Having selected the rows and columns and then either selecting a 3D column or XY scatter produces a chart where all the y values are zero, and the x values are at a single point. The title of that chart is strangely given as one row of that data. Believing that the numbers may be taken as text (though they're not in quotes), I've changed the font and the numbering format of the cells, all to no avail. I believe that there was an error when first loading the sheet regarding the format, but that no longer shows.
What is wrong with the data and how can I get a graph or chart of the data?
What is wrong with the data and how can I get a graph or chart of the data?
corus





RE: Charts of data are all zero
As an experiment, try selecting one of the trouble cells, hit F2 and then <Enter>. If the left-right justification switches, then it had a residual text format. If the table is relatively small, you can repeat that to get all the entries back into numeric format.
TTFN
RE: Charts of data are all zero
corus
RE: Charts of data are all zero
My solution is exactly the same as yours.