Pie Chart in the report

Ravi Kumar

Registered User.
Local time
Tomorrow, 00:27
Joined
Aug 22, 2019
Messages
162
dear all ,
I have attached my report for your reference , I need a pie chart of the same but in %.in the bottom of it.
could u please explain the steps on how to do it??
 

Attachments

  • chart requirement.JPG
    chart requirement.JPG
    99.5 KB · Views: 155
OK so you want something that looks a little like this

attachment.php


Have you had any answers from other forum(s)?
What have you tried?

There's nothing special about pie charts though the approach will depend on whether you are using traditional charts or the modern charts supplied with Access 365.

In either case you need the chart record source to be based on the data underlying those figures - presumably a query

However its not possible to tell you exactly what without knowing your table/query structure. Suggest you upload a cut down version of your database with that info removing anything confidential
 

Attachments

  • PieChart.PNG
    PieChart.PNG
    4.2 KB · Views: 339
Ravi
Not sure why you created another new thread in reports but I tried moving your post here but messed it up. Somehow lost yours whilst moving that of the DB Guy who reported it.

Please can you repeat your last post and uploaded file ...to this thread!
 
Ravi
Not sure why you created another new thread in reports but I tried moving your post here but messed it up. Somehow lost yours whilst moving that of the DB Guy who reported it.

Please can you repeat your last post and uploaded file ...to this thread!

ok I think you want me to repeat the question ..
I need a pie chart based on the two calculated text fields in my report .
I have attached my query file , table & report for your reference.
kindly help me .
 

Attachments

  • table.JPG
    table.JPG
    51.2 KB · Views: 151
  • qur for partiuclar section.JPG
    qur for partiuclar section.JPG
    26.7 KB · Views: 139
  • my report.JPG
    my report.JPG
    51 KB · Views: 153
No.
I asked you to post a cut down version of your database or, at the very least, post the sql used for the query which gives the data. Not a screenshot of it.
I also asked you which type of charts you are using.

The data shows number fields. Not text fields.
 
if you can post a db containing those in images in your attachments (1 table, 1 query, 1 report), I will make you a nice report with pie chart (plus extra Cola).
 
if you can post a db containing those in images in your attachments (1 table, 1 query, 1 report), I will make you a nice report with pie chart (plus extra Cola).
dear sir ,
I have already attached my complete database , pls do the needful.
thank you very much.
 
No.
I asked you to post a cut down version of your database or, at the very least, post the sql used for the query which gives the data. Not a screenshot of it.
I also asked you which type of charts you are using.

The data shows number fields. Not text fields.
sir , I have attached my database in the thread.
 
Yes I know but as arnel is now offering to do the chart for you I'll leave it to him
 
I am building the report in excel, so the report will
load slow.
 

Attachments

I am building the report in excel, so the report will
load slow.

hello sir ,

Thank you so much for your help,
but pls clarify my below doubts:
1. Is the data to the graph should be entered manually in excel every time ?

2. I have made a report called "Charts" in my database , can it be changed to pie format(take the data for one date only , as for 2 dates it is not possible)?

4. That is really such a good as well as complex code, can u share any guide related to VBA , so that I can also learn along?
 
hello sir ,

Thank you so much for your help,
but pls clarify my below doubts:
1. Is the data to the graph should be entered manually in excel every time ?

2. I have made a report called "Charts" in my database , can it be changed to pie format(take the data for one date only , as for 2 dates it is not possible)?

4. That is really such a good as well as complex code, can u share any guide related to VBA , so that I can also learn along?

Any help please.
 
you don't manually enter the data in excel.
I automate the insertion of data.
save the chart as picture and show it in the report.
 
you don't manually enter the data in excel.
I automate the insertion of data.
save the chart as picture and show it in the report.

Sir I think you didn't see my second and third doubts...can you check it once please..
 

Users who are viewing this thread

Back
Top Bottom