MS Access Chart formatting programmatically RRS feed

  • Question

  • I have a Table called Revenue_Sum which always contains twelve rows with two columns as Month and Sum as shown below. I would like to display those records in chart with different format [color] programmatically. say -


    Jan - Red


    MAr - green



    with the help of code!




    Month Sum
    1/1/2006 1033792
    2/2/2006 1943119
    3/3/2006 1765011
    4/4/2006 1676636
    5/5/2006 615000
    6/6/2006 1545000
    7/7/2006 2940000
    8/8/2006 3525000
    9/9/2006 4710000
    10/10/2006 4910000
    11/11/2006 5295000
    12/12/2006 5295000

    Plese help me!



    Saturday, June 10, 2006 5:19 AM


  • Hi,

    What your looking to do will depend on how you create the graph.

    If you add all your data to one series (of a bar chart) then you won't be able to change the colour of the individual bars. They are all treated like one.

    If on the other hand you plot each row to a seperate series then you can change the colour of each individual bar.

    The chart object in Access is the same as the chart object in Excel. There might be some changes but basically they are the same component. It means if you look online for Excel examples of changing a series colour (or even record a macro) then you should have an idea of how to do it.

    Hope that helps.

    Monday, June 12, 2006 7:31 AM