Solved Can a pie chart be made from a query in Access 2007? (1 Viewer)

[ChrisC]

Hi guys,

Just a quick question for you today... can a pie chart be made from a query in Access 2007? The query has 3 fields in it but no matter what I do I just cant get the damn thing to show all of them on the chart - its only one or the other and its beginning to give me a complex!

thank you AS ALWAYS!
Chris

 

[mike60smart]

Hi Chris

Can you upload a zipped copy of the Db?

 

[ChrisC]

Hi Mike, I will try - bear with me though, there are some company bits of info in there that I need to clear out first

 

[ChrisC]

Please find attached the DB.

IT is FAR from finished and lots of functionality to perfect however, I have created qryStockITemCountforGraph which draws info from 3 other queries. There are 3 fields in the query, each with their own numeric value. These represent the number of items (parts) at, below and above minimum level.

On the form called frmControlPanel I want to show a pie chart that displays the info from the above query; however I just cant seem to apply each of the fields to the chart - just the one.
The 3 fields I want too display are shown in the wizard, but I can only drag over one into the series field and truth be told I do not know what goes in the Data field at all!

I have no doubt that it is very simple to actually do, just as it is in Excel - however I just cant work it out!

many thanks
Chris

 

[mike60smart]

Hi Chris

To obtain the results in 1 query I created a UNION query based on your 3 original queries.

See the Pie Chart in the attached

 

[ChrisC]

Hi Mike,

Great stuff - Thank you very much - I will have a look

Chris

 

[arnelgp]

you have Old chart (A2007) while the other has the Modern Chart (2016-2019) which will not run on A2007.
this is in between, Excel Chart.

 

[ChrisC]

Hi Arnel,

Thanks very much! that works great.

Thanks also Mike, but sadly as I have 2007 your version didn't work for me. thank you for your help though!

 

[ChrisC]

Arnel - Where does the Excel spread sheet get saved? Or is it all essentially created "virtually" only whilst the DB is open?

Many thanks
Chris

 

[Gasman]

you have Old chart (A2007) while the other has the Modern Chart (2016-2019) which will not run on A2007.
this is in between, Excel Chart.

I will not pretend I understand all of that, but pretty neat all the same.

 

[arnelgp]

the Excel workbook is saved in tblExcel as Attachment.

 

[ChrisC]

ah yes - I see that now, thank you