Hi, so I've been asked by my boss to see about starting a chart of warehouse production by week in several different categories. He is the first one in any job I've ever had to ask me to use the chart feature in Excel so sadly, my chart knowledge is sorely lacking. I want to make a chart that will compare up to 7 categories week by week and all I can think to do is just copy and paste each week with a 1 row gap between each. The data I exported to Excel looks like this layout:
I pasted the one for current week right below last week's leaving a row gap in between them. So at this point, I am completely lost on what to do. I am guessing he wants to compare the Perf % numbers on each week in column B that go with column A's headers. Mind you, this will be an ongoing thing that I add to as we complete a week, so the chart will be updated. I just have no idea where to go from here once I paste the data. Is pasting the data one space below like I have the best way to do this or is there better? If I could get some guidance on this, it would be much appreciated!
I pasted the one for current week right below last week's leaving a row gap in between them. So at this point, I am completely lost on what to do. I am guessing he wants to compare the Perf % numbers on each week in column B that go with column A's headers. Mind you, this will be an ongoing thing that I add to as we complete a week, so the chart will be updated. I just have no idea where to go from here once I paste the data. Is pasting the data one space below like I have the best way to do this or is there better? If I could get some guidance on this, it would be much appreciated!
