Pie Chart in the report

[Ravi Kumar]

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??

 

[isladogs]

Crossposted at https://www.accessforums.net/showthread.php?t=78365&p=439909#post439909

Ravi
Please read this link about crossposting https://www.excelguru.ca/content.php?184

I've deleted your duplicate post

 

[Ravi Kumar]

Crossposted at https://www.accessforums.net/showthread.php?t=78365&p=439909#post439909

Ravi
Please read this link about crossposting https://www.excelguru.ca/content.php?184
I've deleted your duplicate post

Okay I didn't know that...
But can you please help me on the problem above?

 

[isladogs]

OK so you want something that looks a little like this

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

 

[theDBguy]

Re: pie chart

Hi. Is this a duplicate post?

 

[Gasman]

Re: pie chart

Hi. Is this a duplicate post?

It was. O/P seems to like to post in stereo. Did it with another subject today.

 

[isladogs]

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 Kumar]

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 .

 

[isladogs]

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.

 

[Ravi Kumar]

I have attached my database.

 

[arnelgp]

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).

 

[Ravi Kumar]

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.

 

[Ravi Kumar]

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.

 

[isladogs]

Yes I know but as arnel is now offering to do the chart for you I'll leave it to him

 

[arnelgp]

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

 

[Ravi Kumar]

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?

 

[Ravi Kumar]

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.

 

[arnelgp]

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.

 

[Ravi Kumar]

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..