F
falloutx
I have a problem with the filtering options for the advance filtering
and hope someone can help me with it.
Sheet1 is my database and Sheet 2 is the information I need to plot a
graph
1) Sheet1!G1:I2 contains the advance filtering criteria, I want to find
only Level 2 and within the week range stated in Sheet2!E1:G1. But it
does not work.
2) Can I plot 2 different graphs into a single chart? Eg. Using the
information gotten out in Sheet2!A1:B11, I plot graph 1. and using the
same x axis(Part) and the value in the Target column in sheet2 to plot
graph 2. Can I place both graphs in the one chart?
+-------------------------------------------------------------------+
|Filename: report.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4236 |
+-------------------------------------------------------------------+
and hope someone can help me with it.
Sheet1 is my database and Sheet 2 is the information I need to plot a
graph
1) Sheet1!G1:I2 contains the advance filtering criteria, I want to find
only Level 2 and within the week range stated in Sheet2!E1:G1. But it
does not work.
2) Can I plot 2 different graphs into a single chart? Eg. Using the
information gotten out in Sheet2!A1:B11, I plot graph 1. and using the
same x axis(Part) and the value in the Target column in sheet2 to plot
graph 2. Can I place both graphs in the one chart?
+-------------------------------------------------------------------+
|Filename: report.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4236 |
+-------------------------------------------------------------------+