Problem chart (1 Viewer)

rainbows

Registered User.
Local time
Today, 14:35
Joined
Apr 21, 2017
Messages
425
HI , I am trying to create a chartin a report and not doing so well . at this time i type the data into excel and create a chart which is not really what i would like to do as the information is in access i have attached a sample of the database and a screen shot of what i woud like it to be in an access report could you please have a look and look at what i am doing wrong

thank you steve

1653058054927.png

1653058086092.png
 

Attachments

  • CHART.accdb
    2.5 MB · Views: 147

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:35
Joined
May 7, 2009
Messages
19,169
use your Excel graph.
add an Image control to your report
save your excel chart as Image and
set the Picture property of the image on the report to the
name of the saved image.

see this demo.
 

Attachments

  • Charting (arnel).accdb
    836 KB · Views: 149

rainbows

Registered User.
Local time
Today, 14:35
Joined
Apr 21, 2017
Messages
425
thank you

as i am not good with charts i have tried for hours to do what was suggested in the last post but failed i have managed to do a chart but i would like also a percentage within each column if possible like the screen shot i posted early

thank you steve
 

Attachments

  • CHART.accdb
    2.5 MB · Views: 144

kochmax1

New member
Local time
Tomorrow, 02:35
Joined
Apr 27, 2022
Messages
2
Thanks for sharing such a good solution. It's really helpful for my project ranboo merch store here.
 

Attachments

  • ranboo cart sheet.txt
    31 bytes · Views: 150

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:35
Joined
May 7, 2009
Messages
19,169
the chart from Excel put into your report.
 

Attachments

  • CHART.accdb
    844 KB · Views: 141

Users who are viewing this thread

Top Bottom