J
Jeff Harbin
I am using Excel 2003 and I've got a chart that is linked to data
located on another sheet within the same workbook. It is a weekly
production report and it always records a 0 for the weekends since we do
not produce anything on Saturday or Sunday. The data is extracted from
another source - not manually entered - and will always have the
weekends included. The chart is structured such that the 'Y' axis is
comprised of the values on the Data worksheet in column X, rows 14
through 49 ($X$14:$X$49) and represent the production yields. The 'X'
axis is taken from the Data worksheet in column A, rows 14 through 49
($A$14:$A$49) and represents the production date.
I know that if I clear the contents of the cells that correspond to the
weekends with a 0 production value and the cells that correspond to the
date identifier, I will get exactly what I want.
I conspired to add 2 more columns to the Data worksheet - Adjusted_Date
& Adjusted_Yield. I planned to populate these cells with the
corresponding values from Date & Yield. I thought if I could assign the
new columns - Adjusted_Date & Adjusted_Yield based on the Yield field, I
could get the formatting I want.
However, I am unsure of how to write a formula that will assign an Empty
cell based on the value of another cell.
For example: If the Yield value in Row 14 is 12%, I want the
Adjusted_Yield to be 12% and the Adjusted_Date to be equal to the value
of Date. On the other side...if the Yield value in Row 14 was 0%, I
want the Adjusted_Yield and the Adjusted_Date to be empty.
Or...am I making this too complicated and there's an easier way to
accomplish what I want.
Thanks.
Jeff
located on another sheet within the same workbook. It is a weekly
production report and it always records a 0 for the weekends since we do
not produce anything on Saturday or Sunday. The data is extracted from
another source - not manually entered - and will always have the
weekends included. The chart is structured such that the 'Y' axis is
comprised of the values on the Data worksheet in column X, rows 14
through 49 ($X$14:$X$49) and represent the production yields. The 'X'
axis is taken from the Data worksheet in column A, rows 14 through 49
($A$14:$A$49) and represents the production date.
I know that if I clear the contents of the cells that correspond to the
weekends with a 0 production value and the cells that correspond to the
date identifier, I will get exactly what I want.
I conspired to add 2 more columns to the Data worksheet - Adjusted_Date
& Adjusted_Yield. I planned to populate these cells with the
corresponding values from Date & Yield. I thought if I could assign the
new columns - Adjusted_Date & Adjusted_Yield based on the Yield field, I
could get the formatting I want.
However, I am unsure of how to write a formula that will assign an Empty
cell based on the value of another cell.
For example: If the Yield value in Row 14 is 12%, I want the
Adjusted_Yield to be 12% and the Adjusted_Date to be equal to the value
of Date. On the other side...if the Yield value in Row 14 was 0%, I
want the Adjusted_Yield and the Adjusted_Date to be empty.
Or...am I making this too complicated and there's an easier way to
accomplish what I want.
Thanks.
Jeff