I am not good at Excel so I hope that I can ask this and have it make sense
to someone.
I enter data into a spread sheet. At the top (which will be my catagory X
axis tables)are lot numbers of a product.
I begin by putting in my lot numbers. Beneath each lot number I enter how
many returns in a particular month I have had for each. At the end of that
row, I put the month "JAN".
I then highlight it all and make a nice little chart which I do not embed in
the sheet, but make it another page. That's all good!
I go to the next month. Under the lot numbers I already have listed I enter
how many returns I have had for February and at the end of that row, I put
"FEB". That is good. BUT....I have 5 more lot numbers to add too. So, I add
those to my lot numbers at the top and enter the values for them. Of course
for those I have to enter "0" in my January row. I highlight it all and have
my February chart -which shows lot numbers and returns for both months.
So, I have my excel sheet and two charts JAN - which shows lot numbers and
returns for JAN. And FEB, which shows lot numbers and retrurns for JAN and
FEB.
What I do not want to happen is.....the lot numbers that I entered in FEB
that were not relevant in January (those that I had to put "0"s in for) - I
don't want them automatically popping up in my January chart.
See-- say I only had 6 lot numbers in January that I had returns for. Then
in Feb I have 10. When I enter those on my excel sheet they automatically
pop into my January chart.
I know this is probably a stupid question and I apologize. Is there some way
to eliminate those lot numbers and all the zeros from showing on the chart
UNTIL the month that the particular lot number needs to be shown?