UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Removing Axes From A Modern Chart, Access 2016    
 
   
mrtn
post Mar 11 2020, 05:25 AM
Post#1



Posts: 1
Joined: 11-March 20



Hi

I am trying to remove both X & Y axes from the Access modern chart and failing miserably. I am trying to produce a bar chart which looks as the one attached.

Alternatively, if the colour could be changed that would do the trick but I can't see that option either... Nothing on google to change it in the VBA either so any help would be appreciated.


Attached File(s)
Attached File  Annotation_2020_03_11_094659.png ( 5.5K )Number of downloads: 5
 
Go to the top of the page
 
BentBrain
post Mar 27 2020, 08:23 AM
Post#2



Posts: 569
Joined: 10-February 03
From: Thailand


Hi mrtn
Here is a link to a site that has lots of information on the subject including dealing with charts with VBA

Few simple examples for creating Graph Charts in MS-Access:

http://msaccess-tips.blogspot.com/2007/08/...aph-charts.html
http://msaccess-tips.blogspot.com/2007/09/...ph-charts2.html

Yes, you can add trend lines in Access too. If you are a VBA Programmer you can do lot more things in Access by manipulating Chart Objects as well.

http://msaccess-tips.blogspot.com/2008/06/...ect-in-vba.html
http://msaccess-tips.blogspot.com/2008/07/...rt-and-vba.html
http://msaccess-tips.blogspot.com/2008/07/...ct-and-vba.html

You may download a database with all the VBA Code and running version of all the charts from the above pages.

Let me know if that helps
BB

--------------------
"There is no excellent beauty that hath not some strangeness in the proportion" Francis Bacon
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    10th July 2020 - 11:12 AM