Problem was the same typo error

Doh!

wk1,wk2,wk3 go across the page

You mean you want it by row rather than by column? This is done by altering
the OFFSET arguments. Check this out in the help files or look at the
example in more depth to understand how Offset identifies a particular
range.

and show the data on the chart for Forecast and Releases only?

Just have those two series in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:6d1ffb0018e51@uwe...
Hi Jon

Have been throgh this again and again, until Presto ! got it. Problem was
the same typo error, - learnt a lesson here !

Could i ask one last question, my headings go across the page, wk1,wk2,wk3
etc. Down the column reads, Forecast,Releases,Deliveries,Lates,etc. Is
it
possible to adapt the chart to enable the operator to select the range of
wks
and show the data on the chart for Forecast and Releases only?

Regards

Jon Peltier wrote:
I just walked through the instructions to make sure I hadn't left anything
out. I had no issues, so the written steps seem okay. Things to check:

Sheet is named Data (not case sensitive, Excel corrects it).

Ranges ChartFirmA etc. exist (also not case sensitive).
Go to Insert menu Names Define. Are the names listed? Click in the
Refers To box of each: is the correct range highlighted in the worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

Thanks Jon, this is just what i am looking for and would be brill if i
can
master it.
[quoted text clipped - 35 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1