The only posts I've been able to find on this subject are ~10 years old. Surely things have changed since then. I have a table that is date ordered descending (most current date & data on top). Numbers plots the x-axis from right to left. Is there a way to reverse the graph to plot the data left to right, without reversing the sort order of the table? TIA.
If this is a category chart, the values on the horizontal axis are categories, and have no numerical (or quasi-numerical) meaning,
Categories, listed in a column, will be placed left to right on the category axis in the same order as they are listed, top to bottom, in the table from which the chart gets its data.
The table feeding the chart does not have to be the tale on which the data was entered.
In this example, the Data is the data entry table; TO CHART is the table from which the shart gets its data.
The dates on Data are reversed on TO CHART using the formula shown below the tables, entered into TO CHART::A2, and filled down to the last row.
The data for each date is collected using a formula with MATCH and INDEX to lookup the date and return the data from the same row of the first table.
Limitation: The formula as shown above collects the data from the earliest dates in the list, If you are plotting ALL the dates in the list in Data, no problem—you'll need only to keep the TO CHART table the same length (in rows) as the Data table, and occasionally expand the chart to accommodate the added number of data points.
Here are the same two tables, with another 5 dates and data added to the Data table. The TO CHART table still set to hold only 9 dates, but these are now the 9 most recently entered dates, with the entries in reverse order. to those in the Data table.
Provided new entries are made in the order they occur, and always in a new "Row 2"cell (created most easily be selecting any cell in row 2, then pressing option-up arrow to insert a new row above the selected cell), the formula will capture the most recent nine dates in column A, and list them in reverse order in the column containing the formula.
The same formula, filled right to column B of TO CHART, will capture the data from the same rows of column B of Data, and list them in the reverse order in column B.
The fixed value (12) is set to the sum of the row number of the row containing the first value to be charted plus the row number of the last value to be charted, In the example, these are rows 2 (most recent date) and 10 (earliest date to be included).
Regards,
Barry
PS: The number of markers on the value (y) axis was changed manually (in the Chart Inspector) to avoid non-integer values being placed as labels on this axis.
B.
If this is a category chart, the values on the horizontal axis are categories, and have no numerical (or quasi-numerical) meaning,
Categories, listed in a column, will be placed left to right on the category axis in the same order as they are listed, top to bottom, in the table from which the chart gets its data.
The table feeding the chart does not have to be the tale on which the data was entered.
In this example, the Data is the data entry table; TO CHART is the table from which the shart gets its data.
The dates on Data are reversed on TO CHART using the formula shown below the tables, entered into TO CHART::A2, and filled down to the last row.
The data for each date is collected using a formula with MATCH and INDEX to lookup the date and return the data from the same row of the first table.
Limitation: The formula as shown above collects the data from the earliest dates in the list, If you are plotting ALL the dates in the list in Data, no problem—you'll need only to keep the TO CHART table the same length (in rows) as the Data table, and occasionally expand the chart to accommodate the added number of data points.
Here are the same two tables, with another 5 dates and data added to the Data table. The TO CHART table still set to hold only 9 dates, but these are now the 9 most recently entered dates, with the entries in reverse order. to those in the Data table.
Provided new entries are made in the order they occur, and always in a new "Row 2"cell (created most easily be selecting any cell in row 2, then pressing option-up arrow to insert a new row above the selected cell), the formula will capture the most recent nine dates in column A, and list them in reverse order in the column containing the formula.
The same formula, filled right to column B of TO CHART, will capture the data from the same rows of column B of Data, and list them in the reverse order in column B.
The fixed value (12) is set to the sum of the row number of the row containing the first value to be charted plus the row number of the last value to be charted, In the example, these are rows 2 (most recent date) and 10 (earliest date to be included).
Regards,
Barry
PS: The number of markers on the value (y) axis was changed manually (in the Chart Inspector) to avoid non-integer values being placed as labels on this axis.
B.
Thanks Barry. I will play with this and let you know if I have any additional questions. However, even as a category chart, one would think it would be fairly simple for Apple to include a chart option that reverses the direction it plots the data. From what I found online, Excel includes this ability.
Numbers: Reverse X-axis Direction
