B
B141
Office 2003 version:
I'm having trouble with learning/applying correct syntax. Please help me
shorten the series for a stacked column chart. Example:
=SERIES("DX
only",(Nov!$E$69,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$80,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$91,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$102,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$113),(Nov!$E$70,Nov!$I$70,Nov!$N$70,Nov!$H$70,Nov!$O$70,Nov!$S$70,Nov!$Z$70,Nov!$E$81,Nov!$I$81,Nov!$N$81,Nov!$H$81,Nov!$O$81,Nov!$S$81,Nov!$Z$81,Nov!$E$92,Nov!$I$92,Nov!$N$92,Nov!$H$92,Nov!$O$92,Nov!$S$92,Nov!$Z$92,Nov!$E$103,Nov!$I$103,Nov!$N$103,Nov!$H$103,Nov!$O$103,Nov!$S$103,Nov!$Z$103,Nov!$E$114),1)
I'm having trouble with learning/applying correct syntax. Please help me
shorten the series for a stacked column chart. Example:
=SERIES("DX
only",(Nov!$E$69,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$80,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$91,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$102,Nov!$I$59,Nov!$N$59,Nov!$H$59,Nov!$O$59,Nov!$S$59,Nov!$Z$59,Nov!$E$113),(Nov!$E$70,Nov!$I$70,Nov!$N$70,Nov!$H$70,Nov!$O$70,Nov!$S$70,Nov!$Z$70,Nov!$E$81,Nov!$I$81,Nov!$N$81,Nov!$H$81,Nov!$O$81,Nov!$S$81,Nov!$Z$81,Nov!$E$92,Nov!$I$92,Nov!$N$92,Nov!$H$92,Nov!$O$92,Nov!$S$92,Nov!$Z$92,Nov!$E$103,Nov!$I$103,Nov!$N$103,Nov!$H$103,Nov!$O$103,Nov!$S$103,Nov!$Z$103,Nov!$E$114),1)