Hello. I have a high-low-close chart that currently has all red bars. I would like every other bar to be red, and the rest to be blue though. However, when I try to change the color of the High-low-close lines, it changes them all at the same time as opposed to letting me change the color of each individually. There are three series in the chart currently. Series 1 are the low data points, series 2 are the high data points, and series 3 are the close data points. When I try to add in a series 4,5, and 6 by selecting the data that would go with every other bar, it doesn't seem to add the data where/how I want it to. I did find this thread here, but I don't understand the part about moving both sets of data to an empty sheet as chart objects. The data is already all on the same page, so I'm not exactly sure what to do. If anyone could give a step by step guide on how to make every other bar in a high-low-close chart an alternate color, it would be very much appreciated.
Bookmarks