Hi jon

Yes, have previously visited your site and have duplicated your example,
however, don't know how to show adjust your settings to unable graph to show
two bars per week

week numbers running along the row (row 5)
Forecast,Releases, Delivery, running down in column A

wishing the operator to select select 4 weeks of data, showing Forecast
verses Released. Which should show two vertical bars per week?

I thought Shane's approach was going to work, but could not adapt formula to
my layout of data

Appriciate you patience

regards



Jon Peltier wrote:
Something like this?

http://peltiertech.com/Excel/Charts/ChartByControl.html

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

Thanks Shane, I have not egnored you reply, gust been trying to adapt my
data
[quoted text clipped - 54 lines]

Brian

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