Change color of bar graph w/automation

D

Dale

Hi
I have several bar graphs called from a within a MsAccess user form. I
would like to change the color of the bars depending on what option is
selected. I can't figure out the correct syntax to do this...thanks in
advance...

Case 6
'Stat InLab to Verified
strsql = "my_query"
Me!Graph0.RowSource = strsql

With objGraph
.HasTitle = True ' Add some titles
.ChartTitle.Text = "STATs: InLab to Verify 90th Percentile (Total
time from InLab)" _
& Chr(10) & "Target 60 min"
.SeriesCollection(1).??????????????? << how do I reference the
series?

Thanks for your help...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

colors in bar graphs 1
Color change on bars when goal met 2
changing the color of a single bar on a graph 1
How do I change the color of each bar in my graph? 4
Changing Colors of Bar Graphs 5
How do I change the bar graph color for vacation days on Resource. 4
lines/bar chart- on max valued bar, change color 7

Top