Chart formatting

[jherzog]

How can I use conditional formatting in an access 2010 chart. I wish to dynamically change the color of the bar charts based on a field from the query used for the chart.

[June7]

With a lot of VBA code. I experimented with what you describe and it was quite challenging. https://www.accessforums.net/reports...ort-35298.html

[jherzog]

Thank you June7 for your quick reply. Perhaps an image of what I am trying to do would clarify. Columns in the chart need to vary colors by values from the charts query as shown.

[June7]

If the procedure can work with hard-coded color assignments, I am sure a table as source of color assignments can be worked in. Get the hard-coded functional for a start.