VBA to color data points in a Chart based on non-graphed column values

**shellig** · 05-04-2005, 04:52 PM

Instead of data labels, I sometimes go in and manually change data point colors based on values in another column (like yield values that are graphed and color changes based on input material lot number). What is annoying about this is if the data range of the graph is changed, the colors that I put in manually are no longer correct.

I am trying to figure out a VBA way to color the data points
Here is my first shot.
I am stuck though. See the ** comments in the code.

Please Login or Register  to view this content.

**shellig** · 05-10-2005, 09:46 AM

I could probably solve some of the issues by asking the user what column the data is in, what row to start with, and what column to change the colors by.
I haven't done that because I would like to take the chart as plotted and have it automatically update the colors, even if the range is changed.
I have not seen anywhere where I can pull out the range column or row to input as variables in a loop. I am sure this can be done but am clueless how!!

Updated code:

Please Login or Register  to view this content.

Thanks for any who have suggestions!
Shelli

VBA to color data points in a Chart based on non-graphed column values

LinkBack

Thread Tools

Rate This Thread

Display

VBA to color data points in a Chart based on non-graphed column values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions