Pie Chart in the report (1 Viewer)

Ravi Kumar · Sep 24, 2019

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 · Sep 24, 2019

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 · Sep 24, 2019

isladogs said:
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 · Sep 24, 2019

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 · Sep 24, 2019

Re: pie chart

Hi. Is this a duplicate post?

Gasman · Sep 24, 2019

Re: pie chart

theDBguy said:
Hi. Is this a duplicate post?

It was. O/P seems to like to post in stereo.

Did it with another subject today.

isladogs · Sep 24, 2019

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 · Sep 25, 2019

isladogs said:
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 · Sep 25, 2019

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 · Sep 25, 2019

I have attached my database.

arnelgp · Sep 25, 2019

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 · Sep 25, 2019

arnelgp said:
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 · Sep 25, 2019

isladogs said:
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 · Sep 25, 2019

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

arnelgp · Sep 25, 2019

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

Ravi Kumar · Sep 25, 2019

arnelgp said:
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 · Sep 25, 2019

Ravi Kumar said:
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 · Sep 25, 2019

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 · Sep 25, 2019

arnelgp said:
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..

Pie Chart in the report (1 Viewer)

Registered User.

Attachments

MVP / VIP

Registered User.

MVP / VIP

Attachments

I’m here to help

Enthusiastic Amateur

MVP / VIP

Registered User.

Attachments

MVP / VIP

Registered User.

Attachments

..forever waiting... waiting for jellybean!

Registered User.

Registered User.

MVP / VIP

..forever waiting... waiting for jellybean!

Attachments

Registered User.

Registered User.

..forever waiting... waiting for jellybean!

Registered User.

Similar threads

Users who are viewing this thread