2007 Access Change Color in bar graph using VB RRS feed

  • Question

  • I have created a bar Graph in Access. It has three categories.
    Categories are
    1. On Time      GREEN
    2. -1 to -5      YELLOW
    3. -6 or More  RED

    When Selecting the Data from a Query The data may change and may have 1 category of the three or any two categories of the three or all three.

    The BAR colors Need to be constant  Green, Yellow or Green.
    How can I change the colors of the graph in VISUAL BASIC based upon the Data in the Query?
    The user can select the Company which selects the Data for the query.
    The query is a Pivot Table

    • Edited by Rosenlu Saturday, August 17, 2013 8:14 PM
    Saturday, August 17, 2013 8:11 PM

All replies