Bryan Schmidt
asked on
How to modify the width of bars in an Access column graph where Access is part of Office 365
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.
How you want to perform the modification ...via code or on design view ?
ASKER
I prefer design view. If that doesn't work I will try doing it in code if it's not too complex.
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.ChartSeriesCo llection.I tem(0).Fil lColor=225
...Me.Chart0.ChartSeriesCo llection.I tem(0).Bor derColor=0
...again, I saw nothing for the gap width, ...ex.:
Me.Chart0.ChartSeriesColle ction.Item (0).GapWidth
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.ChartSeriesCo
...Me.Chart0.ChartSeriesCo
...again, I saw nothing for the gap width, ...ex.:
Me.Chart0.ChartSeriesColle
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ok