Dynamic stacked bar chart?

[shawn212]

So far all the examples of dynamic charts I've seen have only had tw
colums -1 for chart labels and the other with the data. My data ha
week ending dates in column A(chart labels), column B has monday'
sales - C has tues' sales....column F has Friday's sales. Also, I onl
want to graph the data that is currently available in a data set tha
will continue to grow. In the end, each bar should represent a week
worth of sales with mon-fri stacked. Any ideas?
Thanks for your help in advance.

Shaw

 

[Jon Peltier]

Shawn -

Well, how did you get the first series? A dynamic range for the
categories and another for the values. MyX and MyY. For multiple series,
use MyX for the categories, assuming they're shared by all the series,
then use MyY1, MyY2, etc for the values. Whatever formulas you used for
the dynamic behavior can be extended to the other ranges.

I have a trick to make ranges easier to define. I use my offsets and
counts in the categories:

MyX refers to:
=OFFSET(A1,1,0,counta(A:A),1)

MyY1 refers to:
=OFFSET(MyX,0,1)
MyY2 refers to:
=OFFSET(MyX,0,2)
MyY3 refers to:
=OFFSET(MyX,0,3)
etc.

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