A simple pie chart should be no problem with an Access chart. You can copy the datasheet rows and paste into the chart's datasheet. The chart should always reflect the current data when viewed.
> To: MS_Access_Professionals@yahoogroups.com
> From: dbalorenzini@yahoo.com
> Date: Wed, 3 Jul 2013 17:25:02 +0000
> Subject: [MS_AccessPros] Something better than the chart object
>
> Is there something better than using the Access chart object? I have one on my frmDashboard and its a Pie chart but it seems to take for ever to load.
>
> Its was supposed to be based on the following query:
>
> SELECT Count(tblUnit.UnitID) AS [# of Units], tlkpClassificationType.ClassificationTypeName AS Class
> FROM tblUnit INNER JOIN tlkpClassificationType ON tblUnit.ClassificationTypeID = tlkpClassificationType.ClassificationTypeID
> GROUP BY tlkpClassificationType.ClassificationTypeName;
>
> But when I try and edit it, it pops some sort Excel looking datasheet that I have to edit to get my chart to look right. This chart is supposed to change as the data changes but it seems I have to hardcode the changes. I must be missing something.
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls, SD
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar