Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change color of bar graph w/automation
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... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change color of bar graph w/automation
My guess is you are using MS Graph for this chart. You should still be
able to use Excel for the below since MS Graph is a subset of XL's charting capability. In Excel, turn on the macro recorder (Tools | Macro Record new macro...), use the UI to change the color of the plotted series, and turn off the recorder. Switch to the VB Editor and XL *should* give you the necessary syntax. That syntax *should* work with MS Graph. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... 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... |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change color of bar graph w/automation
Thanks Tushar
I should have thought of that... Dale "Tushar Mehta" <tm_200310@tushar_hyphen_mehta_dot_see_oh_em wrote in message om... My guess is you are using MS Graph for this chart. You should still be able to use Excel for the below since MS Graph is a subset of XL's charting capability. In Excel, turn on the macro recorder (Tools | Macro Record new macro...), use the UI to change the color of the plotted series, and turn off the recorder. Switch to the VB Editor and XL *should* give you the necessary syntax. That syntax *should* work with MS Graph. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the color in a graph? | Charts and Charting in Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel |