Microsoft Access
--
Questions
--
Followers
Top Experts
Bar Chart Bar Color Change in MS Access 2007 Using VBA
I have a chart that was created in Excel 2007 and I want to recreate it in MS Access 2007 (WantChart.jpg). What I have so far is very close I just cannot get the bars in each series value to be different colors (HaveChart.jpg). Is there a way to change the bar color without changing the color for the entire series?
Thanks in advance,
Jim
WantChart.JPG
HaveChart.JPG
Thanks in advance,
Jim
WantChart.JPG
HaveChart.JPG
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Open the chart normally, note the color of the bar you want to change
Open the Report/Form in design View
Double-click the chart (Now you are in "Edit Mode")
Right-Click the bar that has the same color as the bar in Normal View
Select: Format data series
Select your desired color....
This is a bit tricky, because if at any point if you click anywhere else, you will throw yourself out of edit mode, and have to double click the chart again
It may take a few tries, ...but after that it becomes easier.
;-)
JeffCoachman
Open the Report/Form in design View
Double-click the chart (Now you are in "Edit Mode")
Right-Click the bar that has the same color as the bar in Normal View
Select: Format data series
Select your desired color....
This is a bit tricky, because if at any point if you click anywhere else, you will throw yourself out of edit mode, and have to double click the chart again
It may take a few tries, ...but after that it becomes easier.
;-)
JeffCoachman
Jeff,
That changes the color for the entire series of bars. Can I change the color of a single bar in the series? And can it be done using VBA?
Thanks,
Jim
That changes the color for the entire series of bars. Can I change the color of a single bar in the series? And can it be done using VBA?
Thanks,
Jim
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Jeff,
YES! That is perfect.
You wouldn't happen to have some vba that could do this too?
Thanks,
Jim
YES! That is perfect.
You wouldn't happen to have some vba that could do this too?
Thanks,
Jim
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.