numbers 2D bar chart - date out of order
I'm tracking my weight with a 2D horizontal bar chart.
There's one entry for each day.
Somehow, one bar is out of order. I can't edit it.
A screen cap is attached.
Mac Pro, OS X 10.11
Question marked as
It happened from the order you chose the rows to include in the chart. I can reproduce it by making a chart of 8/23-9/4 then Editing Data References and choosing 9/12 followed by 9/5-9/10 then 9/13 to the end.
If you select the chart and look at the Format sidebar on the right, Series tab, and click on the field at the top that is labelled "Value", you will see them in that order. Delete all that is there and put the full range in its place. Table 1::B2:B40 (or whatever row it goes to). That will fix it.
In the future when you Edit Data References to add new rows to the chart, drag down on the little circle in the bottom right corner of the selection box to increase the range vs clicking on cells one at a time.