ACCESS FEED: Re: [MS_AccessPros] Charts in Access

Hi Art,

thanks, Bill

> " So do I copy the chart from Excel to my access form after I am done"

Charting seems to be easier in Excel because more is on the menus, but Access can do the same things. If you are just going to put the chart back into Access, perhaps you want to create it there?

here is a link to a couple charting videos for Access:

How To Make a Graph with Microsoft Access (cc)
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
- Create chart, change what data is displayed including formatting, chart type, titles and legend

Tool and Code: Manipulate Graphs in Microsoft Access using VBA (cc)
https://www.youtube.com/watch?v=Zc5WAPderyQ&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
- 20-minute video shows how to drive charts from a menu form that collects criteria, change data for the graph, set the chart title, x-axis title, and modify scales and formats.

I love to make charts ... and do it a lot :) ... here is a link to a chart I made today in Access that tracks views for the MVP Virtual Conference presentation on Access that is posted on Channel 9

http://www.MsAccessGurus.com/temp/Views_VConf_150816.png

Microsoft MVP Virtual Conference Presentation on Access Web Apps, and linking to web databases from Access, Excel, and SSMS (53 min video)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

warm regards,
crystal

~ be awesome today ~

On 8/17/2015 8:50 PM, Bill Mosca wrmosca@comcast.net [MS_Access_Professionals] wrote:

Art
Crystal does a lot of great things with Excel. Maybe she will find time to chime in.

Bill

Sent from my Kindle Fire

From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Mon Aug 17 19:02:19 PDT 2015
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Charts in Access

So do I copy the chart from Excel to my access form after I am done.
With Warm Regards, Arthur D. LorenziniIT System ManagerCheyenne River Housing AuthorityWk.(605)964-4265 Ext. 130Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."

From: "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Monday, August 17, 2015 8:03 PM
Subject: RE: [MS_AccessPros] Charts in Access

Don't get me wrong. I like snazzy as long as it doesn't get in the way of good presentation of data.

You should start by opening Excel and using Data->From Access.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 18 Aug 2015 00:35:27 +0000
Subject: Re: [MS_AccessPros] Charts in Access

Ok, "snazzy" is a bad adverb. Do have an example of how to make the excel/access connection?
With Warm Regards, Arthur D. LorenziniIT System ManagerCheyenne River Housing AuthorityWk.(605)964-4265 Ext. 130Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."

From: "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Monday, August 17, 2015 7:18 PM
Subject: RE: [MS_AccessPros] Charts in Access

"snazzy" is over-rated. You should consider using Excel with links to your Access data.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 17 Aug 2015 17:14:06 -0700
Subject: [MS_AccessPros] Charts in Access

Does any one have any advice on how to get better looking charts in Access 2013. The chart objects that Access provides seems to be really lacking in my opinion. I am creating a dashboard and need a snazzy chart for categories. Any ideas?

Thank you,

Art Lorenzini
Sioux Falls, SD

#yiv3176809446 #yiv3176809446 -- #yiv3176809446ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3176809446 #yiv3176809446ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3176809446 #yiv3176809446ygrp-mkp #yiv3176809446hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3176809446 #yiv3176809446ygrp-mkp #yiv3176809446ads {margin-bottom:10px;}#yiv3176809446 #yiv3176809446ygrp-mkp .yiv3176809446ad {padding:0 0;}#yiv3176809446 #yiv3176809446ygrp-mkp .yiv3176809446ad p {margin:0;}#yiv3176809446 #yiv3176809446ygrp-mkp .yiv3176809446ad a {color:#0000ff;text-decoration:none;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ygrp-lc {font-family:Arial;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ygrp-lc #yiv3176809446hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ygrp-lc .yiv3176809446ad {margin-bottom:10px;padding:0 0;}#yiv3176809446 #yiv3176809446actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3176809446 #yiv3176809446activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3176809446 #yiv3176809446activity span {font-weight:700;}#yiv3176809446 #yiv3176809446activity span:first-child {text-transform:uppercase;}#yiv3176809446 #yiv3176809446activity span a {color:#5085b6;text-decoration:none;}#yiv3176809446 #yiv3176809446activity span span {color:#ff7900;}#yiv3176809446 #yiv3176809446activity span .yiv3176809446underline {text-decoration:underline;}#yiv3176809446 .yiv3176809446attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3176809446 .yiv3176809446attach div a {text-decoration:none;}#yiv3176809446 .yiv3176809446attach img {border:none;padding-right:5px;}#yiv3176809446 .yiv3176809446attach label {display:block;margin-bottom:5px;}#yiv3176809446 .yiv3176809446attach label a {text-decoration:none;}#yiv3176809446 blockquote {margin:0 0 0 4px;}#yiv3176809446 .yiv3176809446bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3176809446 .yiv3176809446bold a {text-decoration:none;}#yiv3176809446 dd.yiv3176809446last p a {font-family:Verdana;font-weight:700;}#yiv3176809446 dd.yiv3176809446last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3176809446 dd.yiv3176809446last p span.yiv3176809446yshortcuts {margin-right:0;}#yiv3176809446 div.yiv3176809446attach-table div div a {text-decoration:none;}#yiv3176809446 div.yiv3176809446attach-table {width:400px;}#yiv3176809446 div.yiv3176809446file-title a, #yiv3176809446 div.yiv3176809446file-title a:active, #yiv3176809446 div.yiv3176809446file-title a:hover, #yiv3176809446 div.yiv3176809446file-title a:visited {text-decoration:none;}#yiv3176809446 div.yiv3176809446photo-title a, #yiv3176809446 div.yiv3176809446photo-title a:active, #yiv3176809446 div.yiv3176809446photo-title a:hover, #yiv3176809446 div.yiv3176809446photo-title a:visited {text-decoration:none;}#yiv3176809446 div#yiv3176809446ygrp-mlmsg #yiv3176809446ygrp-msg p a span.yiv3176809446yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3176809446 .yiv3176809446green {color:#628c2a;}#yiv3176809446 .yiv3176809446MsoNormal {margin:0 0 0 0;}#yiv3176809446 o {font-size:0;}#yiv3176809446 #yiv3176809446photos div {float:left;width:72px;}#yiv3176809446 #yiv3176809446photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3176809446 #yiv3176809446photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3176809446 #yiv3176809446reco-category {font-size:77%;}#yiv3176809446 #yiv3176809446reco-desc {font-size:77%;}#yiv3176809446 .yiv3176809446replbq {margin:4px;}#yiv3176809446 #yiv3176809446ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3176809446 #yiv3176809446ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3176809446 #yiv3176809446ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3176809446 #yiv3176809446ygrp-mlmsg select, #yiv3176809446 input, #yiv3176809446 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3176809446 #yiv3176809446ygrp-mlmsg pre, #yiv3176809446 code {font:115% monospace;}#yiv3176809446 #yiv3176809446ygrp-mlmsg * {line-height:1.22em;}#yiv3176809446 #yiv3176809446ygrp-mlmsg #yiv3176809446logo {padding-bottom:10px;}#yiv3176809446 #yiv3176809446ygrp-msg p a {font-family:Verdana;}#yiv3176809446 #yiv3176809446ygrp-msg p#yiv3176809446attach-count span {color:#1E66AE;font-weight:700;}#yiv3176809446 #yiv3176809446ygrp-reco #yiv3176809446reco-head {color:#ff7900;font-weight:700;}#yiv3176809446 #yiv3176809446ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ov li a {font-size:130%;text-decoration:none;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3176809446 #yiv3176809446ygrp-sponsor #yiv3176809446ov ul {margin:0;padding:0 0 0 8px;}#yiv3176809446 #yiv3176809446ygrp-text {font-family:Georgia;}#yiv3176809446 #yiv3176809446ygrp-text p {margin:0 0 1em 0;}#yiv3176809446 #yiv3176809446ygrp-text tt {font-size:120%;}#yiv3176809446 #yiv3176809446ygrp-vital ul li:last-child {border-right:none !important;}#yiv3176809446

[Non-text portions of this message have been removed]

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>

Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (5)