
Having blank columns and rows in tables of data

Unnecessarily spreading data over different tables Unnecessarily spreading data over numerous worksheets

You can select the green checkmark icon at the same time.Unnecessarily spreading data over many different workbooks If this solved your problem please go to your first post use the Edit button and add to the start of the title. For any additional assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). You will have one column of labels and two columns of data, thus two stacks per stick. You will have one row of headings and 5x4 = twenty rows of data, thus twenty sticks on your chart. In A, put "Day - Team" in A1, "Day1 - East" in A2, "Day 1 - North" in A3, …. Each "Day" will have the 4 columns: "North", "South", "East", and "West" …Use three columns, say A, B, and C.

So "Days" will be on the X-axis, data on the Y.

Jmsld_ wrote:I would like the data for "Day 1 - AVG P/P - East" to be stacked with "Day 1 - Above/Below - East".
