Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: How can I change color of columns of a Graph

    I have a graph:
    Set oChart = CreateObject("OWC.Chart")
    Set c = oChart.Constants

    oChart.Charts(0).Type = oChart.Constants.chChartTypeColumnClustered

    How can I change the color of the columns???
    What is the code??

  2. #2
    Join Date
    Jun 2003
    I'm not sure what OWC is but I've got a free barchart ASP class (no components) downloadable from my Web site at to help turn data stored in a table (or SQL statement) into a barchart and you can explicitly set the colors of the bars or else just use the default colors:

    ' Fill aChartSeriesColor.
    aChartSeriesColor(0) = "#0000FF" ' Could put in something like "blue".
    aChartSeriesColor(1) = "#CC0000" ' Could put in something like "red".
    aChartSeriesColor(2) = "#FF9933" ' Could put in something like "orange".
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts