Originally Posted by
Shocked
I think I may have figured out how to present my data. The problem is I have to transfer the data (date and waste %) to an "all product" sheet and then chart from there. Date in column a, cheerios in column b, quisp in c and so on. In the last column, I have 5% down the entire range as our target.
I am collecting other information for data analysis down the road as well. but for now, we want to get a feel for where we are for each product, and then look at means to improve (and save $).
Is there a way to chart columns and lines having only the 5% column as line an the rest (6-8) charted as columns. I have tried several times and get like 5 columns and the rest as lines or datapoints. What I settled on for now is a column chart with a drawn line 5% representing our target.
Bookmarks