Sorry about the cross post as I didn't read the rules fully. I have posted here https://www.mrexcel.com/forum/excel-...-question.html
i need to chart some data and cant seem to get it correct. I have three columns of data and it will actually increase as well. I can get this data into a pivot table if it is easier. I want to take the first value of columns one and chart only the values in this columns that doesn't have values in columns 2 or 3. then i want to do the same for 2 but no value in 1 and 3. Then i want to chart all the columns together.
Row Labels ITEM A ITEM B ITEM C ITEM D
Team 1 380.12 206.67
Team 2 6248.41
Team 3 451.91 10.89
Team 4 16654.17 726.08
Team 5 230
Team 6 1163.75 542.53
Team 7 16551.79 5987.64
Team 8 4138.88 3334.22 750.61
Bookmarks