Art,
Did you get the data you want to graph into Excel? If so, create a chart or charts in Excel. You typically have a much easier time of creating and modifying charts in Excel.
Your link to the Access data can be refreshed as needed.
Duane Hookom, MVP
MS Access
Did you get the data you want to graph into Excel? If so, create a chart or charts in Excel. You typically have a much easier time of creating and modifying charts in Excel.
Your link to the Access data can be refreshed as needed.
Duane Hookom, MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Tue, 18 Aug 2015 02:02:19 +0000
> 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>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/
>
> <*> Your email settings:
> Individual Email | Traditional
>
> <*> To change settings online go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/join
> (Yahoo! ID required)
>
> <*> To change settings via email:
> MS_Access_Professionals-digest@yahoogroups.com
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
> MS_Access_Professionals-unsubscribe@yahoogroups.com
>
> <*> Your use of Yahoo Groups is subject to:
> https://info.yahoo.com/legal/us/yahoo/utos/terms/
>
> From: MS_Access_Professionals@yahoogroups.com
> Date: Tue, 18 Aug 2015 02:02:19 +0000
> 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>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/
>
> <*> Your email settings:
> Individual Email | Traditional
>
> <*> To change settings online go to:
> http://groups.yahoo.com/group/MS_Access_Professionals/join
> (Yahoo! ID required)
>
> <*> To change settings via email:
> MS_Access_Professionals-digest@yahoogroups.com
> MS_Access_Professionals-fullfeatured@yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
> MS_Access_Professionals-unsubscribe@yahoogroups.com
>
> <*> Your use of Yahoo Groups is subject to:
> https://info.yahoo.com/legal/us/yahoo/utos/terms/
>
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar