How to modify the width of bars in an Access column graph where Access is part of Office 365

Liberty4all
Liberty4all used Ask the Experts™
on
I'm trying to modify the width of bars in an Access column graph but have not been successful.  I'm using Access that is part of Office 365 and it appears to be different than Access 2016 even though comments at the top of the page read Access 2007-2016 file format.  I have watch two online videos on how to create and modify graphs and the functionality demonstrated is different than my version.  Any suggestions on what specific property to modify would be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
How you want to perform the modification ...via code or on design view ?
Liberty4allRetired

Author

Commented:
I prefer design view.  If that doesn't work I will try doing it in code if it's not too complex.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I am not sure if the property you want/need is "exposed" to VBA or design view in the most recent versions of Access.

In Excel it is called "Gap Width"
However, I did not see a way for this to be adjusted in chart design view in access.
You used to be able to modify the individual series in Access charts in design view, ...but now it seems that you can only modify the chart itself.
You can set basic things line the bar and border color (In both design view and VBA), ....but I saw nothing for the gap width.

If you open the chart in design view and click the chart,....you will see the options available to you.
For me, ...I see the "Format" options for the series, ...but nothing for the Gap/Bar Width.

In VBA the command seems to be something like this:
...Me.Chart0.ChartSeriesCollection.Item(0).FillColor=225
...Me.Chart0.ChartSeriesCollection.Item(0).BorderColor=0
...again, I saw nothing for the gap width, ...ex.:
Me.Chart0.ChartSeriesCollection.Item(0).GapWidth
Liberty4allRetired

Author

Commented:
Jeffrey,

Thanks for taking the time to respond.  While Access is my favorite application I wish Microsoft would provide a better graphing tool for it.  I'm currently using Power BI as a substitute graphing tool with Access and it's working well.  I only wish I could find a way to import data directly from 32 bit Access to 64 bit Power BI.  I can import data directly from 32 bit Excel to Power BI so am hoping to find a way to do the same with Access.  I may post a question on this in the near future.

My workaround ("solution") to my question is therefore to use Power BI, even though this means having to first export data from Access to Excel before it can be imported to Power BI.  I'm used to writing code to do this so it's not a big deal but given that Excel is limited to 1,048,576 records it won't work for every project I may do.
Retired
Commented:
See comments to Jeffrey above.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
ok

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial