Andy, I am trying to make a chart with two drop downs, graphing two lines on the same graph. I am using:
LABELS OFFSET(ProjChart!$A$2,0,1,1,7)
LABELS1 OFFSET(ProjChart!$A$6,0,1,1,7)
DATA OFFSET(LABELS,$A$2,0)
DATA1 OFFSET(LABELS1,$A$6,0)
Metric_Name OFFSET($A$2,$A$2,0,1,1)
Metric_Name1 OFFSET($A$6,$A$6,0,1,1)
Chart values: Metric_Name,DATA
Chart values1: Metric_Name1,DATA1
Where the first group of data is in cells A2:U5, with row 2 containing dates; the second group is in cells A6:U9, with row 6 containing the same dates.
I tried to set graph data as ProjChart!Metric_Name = ProjChart!DATA and ProjChart!Metric_Name1 = ProjChart!DATA1, but only the top set of data displays.
Bookmarks