Hi,
Looking for help with a macro that does the following.
Colors the column bars of a chart the same color as the text in the underlying data source of the chart.
Should work even when rows/column_bars are hidden.
Thanks!
Hi,
Looking for help with a macro that does the following.
Colors the column bars of a chart the same color as the text in the underlying data source of the chart.
Should work even when rows/column_bars are hidden.
Thanks!
Are you filling in the color manually, or is the color assigned by conditional formatting? Could you include a sample workbook, please?
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Have you seen these from Jon Peltier? http://peltiertech.com/vba-condition...ategory-label/ which links to other variations These procedures set the bar/column color the same as the cell background color, but it should be easy enough to adapt to font color.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks