excel format

Copper Contributor

lets say on the graph I started a category with 10 items and under that a new category with 10 items. later I decided that the first category needs another item. so how do I add the 11th item at the end of the first category, but on top of the second category created? I guess when it comes to column A, how do I add data in between the rows?

1 Reply
The row where second category appears, right click on row label (on left side) - Insert Rows
You may have to adjust your range in graph
Or
Graph should be dynamically adjusting this. There are various techniques to do so. Easiest is that your data should be structured reference table.