Column Chart to color each day of the week

something like this? chart on sheet 2 series set up on sheet 1 using method from here
http://peltiertech.com/conditional-f...-excel-charts/

sorry that's me for charts! i'll ask someone

Exactly how are you editing the chart and exactly how does it mess up?

I notice that if I move the chart so it is on the same tab as the data, that I can simply grab one of the lower "handles" on the chart range and extend it down. Does the chart need to be on its own tab, separate from the data?

You should be able to accomplish the same thing with the chart on a different tab, though it means going through the "select source data" dialog, which often means editing each series individually. If you try to edit the chart source data field, you may get inconsistent results.

This may be a case where it is easiest, when the chart is first created, to extend the source data range way below the range that is actually needed. Then, as data is added to sheet, these additional data are automatically added to the chart. Or, perhaps this is an example of when using "dynamic named ranges" (a common technique for a variable sized source data range in charts) will be helpful. http://support.microsoft.com/kb/830287

In the attached use named ranges like

mon =OFFSET(Mond,1,0,COUNT(Sheet1!$C:$C))
for each day and cal-date
(mond is the named range for cell D4, which was chosen for the anchor for no particular reason, just...)


Then, in the chart reference them by
series 1: Sheet1!mon, etc.