AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
WIN10x64
------------------------------------------------------------------------
Well, here I go again: today's problem with my treasured Bowling Scores
spreadsheet ! :-[
------------------------------------------------------------------------
In my Calc sheet I have an existing line chart that shows my recent
average bowling scores, e.g., where cell O435 contains the formula:
=IF(D435="";"";AVERAGE(D435:L435)) .
The heading for column O is MATCH AVG. The chart's X-axis should be
reflecting the calculated results in cells $O$415 thru $O450, although
O437 thru O450 do not as yet contain calculated data (my bowling MATCH
AVG scores). The X-axis does show the numbers 1, 2, 3 .... 19, 20 and
21, but data points 20 and 21 are missing from the graph/chart. Calc's
Data Table does not show _Y-Values_ entries adjacent to the
_Categories_ 20 and 21 entries.
What needs to be done to include data points 20 and 21, which correlate
to cells O435 and O436, in the line chart ?? (Cells O435 and O436 do
have a calculated MATCH AVG score for my two most recent sessions at the
bowling alley.)
I cannot seem to locate how to edit the chart's X-axis cell range or
cell series (I don't know/understand which is needed) to include the
latest MATCH AVG data points.
Regards,
VinceB.
