I have a simple column chart.
31 for each day in a bar graph so 31 columns
Is there an easy way to change the colors so that all one day is the same color?
Like
S M T W T F S S M T W T F S S
All the Saturdays 1 color
All the Sundays another color etc.
Please upload an ODF type sample file here (at least the Chart data).
You can set the color for a bar from a column with color values in the spreadsheet. So the idea is to define a table with weekday|color. Then add a column to your data, where the color value is determined by a lookup in this table, using the day of your data. It is not “simple”, but flexible. You can easily change the colors of the weekdays and the chart will adapt automatically to the newly set colors.
CalculatedColors.ods (32.2 KB)
Thank you,
I will work with that. I did see a Video about something close to that idea.
I will create the extra 2 columns for “Value” and “Color” and see if I can “Move” the chart over then 2 columns to cover them, so they are not showing and just the “Date” shows to make it look cleaner.
The formulas should still work even if the “Chart Area” is covering it.
If it don’t and I have to leave it showing that will b fine also.
Thank You Regina,