Solved Forms Chart setting

[Alejo]

Hi Team,

I would like to ask help for the Chart color format.

Trying to copy here the screenshot of the forms output but it doesn't allow me. Attached is the database, kindly open the form and you will see the chart output.

Is there a way to manually change the color of each column and to have a space between them.

Thank you in advance for the response.

 

[MarkK]

Just my 2c, but I use google charts. Using VBA, I write the chart to file as an HTML page, and then load it into a browser control. I find the MS chart package cumbersome. Google's chart developer intro page is here: https://developers.google.com/chart/interactive/docs/gallery

 

[arnelgp]

are you using the "classic" chart or the Modern.
here is the Modern.

 

[Alejo]

are you using the "classic" chart or the Modern.
here is the Modern.

I'm using 2010 access version and the modern chart seems not yet available. Can't migrate yet to latest version as this is the current version we are using in the company.

Still in classic and need to maximize the option in this version.
May I know if there is other way using classic version to customize the chart in the way i wanted to? because for every column I need to reflect on the top the value same as in excel.

 

[Alejo]

hi arnelgp,
In the attached using classic version, the color of the column has the same color.

Trying to change the color of each column and adding the value at the top of the value but can't see the option to do it.
Please advise any alternatives way to do it using classic version

 

[arnelgp]

what you need to do, is on design view of your Dashboard form, "double-click on the chart".
it will bring in another "window".
on that window there are menus, you just need to "explorer".
also on that window you can "right-click" and object on the chart and you
can edit it's property.

 

[Alejo]

what you need to do, is on design view of your Dashboard form, "double-click on the chart".
it will bring in another "window".
on that window there are menus, you just need to "explorer".
also on that window you can "right-click" and object on the chart and you
can edit it's property.

Solved/

Thank you Arnelgp