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
> Pie Chart, Any Version    
 
   
access2009eg
post Dec 13 2019, 05:06 PM
Post#1



Posts: 1,155
Joined: 19-February 08



Hello friends
I have this simple query

CODE
complete       not complete
3                           4


how can I convert this value to the pie chart

I tried but not work in access
but work in excel
I don't know the reason
This post has been edited by access2009eg: Dec 13 2019, 05:06 PM

--------------------
I would like to Thank you for your help
Go to the top of the page
 
isladogs
post Dec 13 2019, 06:26 PM
Post#2


UtterAccess VIP
Posts: 2,180
Joined: 4-June 18
From: Somerset, UK


In Access, both values need to be two separate records in the same field

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
RJD
post Dec 13 2019, 07:06 PM
Post#3


UtterAccess VIP
Posts: 10,205
Joined: 25-October 10
From: Gulf South USA


Hi: Here is an example of what Colin is talking about ... separate records for the values, with the Pie Chart creation. The data are in a table, but works the same with the data in a query result.

HTH
Joe
Attached File(s)
Attached File  PieChart.zip ( 34.63K )Number of downloads: 10
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
access2009eg
post Dec 14 2019, 08:14 AM
Post#4



Posts: 1,155
Joined: 19-February 08



hat_tip.gif

hat_tip.gif
Thanks

working when inverse the data as you explain

thanks.gif
This post has been edited by access2009eg: Dec 14 2019, 08:14 AM

--------------------
I would like to Thank you for your help
Go to the top of the page
 
RJD
post Dec 14 2019, 01:20 PM
Post#5


UtterAccess VIP
Posts: 10,205
Joined: 25-October 10
From: Gulf South USA


I am sure Colin joins me in saying yw.gif

Regards,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
isladogs
post Dec 14 2019, 01:40 PM
Post#6


UtterAccess VIP
Posts: 2,180
Joined: 4-June 18
From: Somerset, UK


I do indeed and thanks to Joe for providing the example to explain what I meant

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th February 2020 - 02:28 PM