I found this example online and its great but I need to add another ability.
I would like to be able to change the value of D2 to be 1, or 2, or 3 and so on that will tell the macro WHICH col to use for the coloring of the chart.
Thank you.
I found this example online and its great but I need to add another ability.
I would like to be able to change the value of D2 to be 1, or 2, or 3 and so on that will tell the macro WHICH col to use for the coloring of the chart.
Thank you.
You would need to code an algorithm for each number that Identifies the fill color(s) and where the colors are applied. Something like a Select Case statement.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Hi
Check attached file.
You can change chart colors by cell D2 (1,2,3 as red, green, blue)
Please Login or Register to view this content.
or doubleClick on region in col A then chart change color to region cell color.
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
thank you for your help on this!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks