MS Access Pie Chart

0
votes

I have to make a pie chart from a request in a MS Access report.

Here is how the data I have looks like :

Data

I basically want a pie chart showing the proportion of each, but it doesn't work and looks like this (with the configuration I have done, but I tested checking all the boxes one by one and it doesn't change) :

wrong pie chart

configuration

I also tried to make a query giving this results :

data 2

And the result is quite the same (a bit better however)

wrong pie chart 2

I think the solution would be to make a request taking my results and placing them in two rows but only one column but I don't know how I could do this. If anyone can help me building this request or finding the solution to tell Access my data are in a row and not in a column, I'd be grateful !

1
sqlms-accesschartsms-access-2016
Can I answer my own question?. You accept an answer. You don't edit the title of your question. – Damien_The_Unbeliever
Yes I know this, but I have to wait for two days to accept the answer :) – Benoit Bouckaert

1 Answers

0
votes

The solution was basic.

I dimply did this :

SELECT [Connexion en cours] + [Connectés] As Connexions
FROM
(
   /*REQUEST 2*/
);