TrippyTom
Well-known Member
- Joined
- Nov 16, 2004
- Messages
- 587
I want to make a bar chart with 1 series, but have the fill color of the company change based on a separate set of values 1 - 5. (which I will have in the next column).
This is slightly different than the examples of conditional charting listed on Jon Peltier's site: http://peltiertech.com/Excel/Charts/ConditionalChart1.html
I was wondering if anyone has tried this, or knows how I would do it. I know I can do this manually but I wanted to search for a more automated way. If you think this would require VBA I'm willing to go that route as well.
This is slightly different than the examples of conditional charting listed on Jon Peltier's site: http://peltiertech.com/Excel/Charts/ConditionalChart1.html
I was wondering if anyone has tried this, or knows how I would do it. I know I can do this manually but I wanted to search for a more automated way. If you think this would require VBA I'm willing to go that route as well.