Graph Data Label Format (1 Viewer)

xyba · Aug 27, 2019

Maybe I'm looking too hard but I can't find a way of changing the format of the data labels in a graph. They default to black but I have a dark background so want to change that.

Does anyone know how to change this value, please?

arnelgp · Aug 27, 2019

on design view of your form, double click the graph.
double click the labels to see its property.

isladogs · Aug 27, 2019

Are you using the 'modern' charts available with Access 365/2019 or the traditional charts available in both earlier versions and current version?

xyba · Aug 28, 2019

arnelgp said:
on design view of your form, double click the graph.
double click the labels to see its property.

Unfortunately that doesn't work for me, arnel.

xyba · Aug 28, 2019

isladogs said:
Are you using the 'modern' charts available with Access 365/2019 or the traditional charts available in both earlier versions and current version?

I'm not too sure. How would I check?

isladogs · Aug 28, 2019

If you are running anything up to and including A2016 retail, it will be a traditional chart.
A2019 retail or 365 has both and it depends which button was used to create the chart:

If its a traditional chart, Arnel's explanation is what you need:

However that doesn't work for modern charts which are easier to create but you have less control over the appearance. Go to the Format tab in the Chart Settings and see if you can find anything there

I don't use them as I find them less useful for my needs so am not an expert on these . However in A365 you can search the Help menu for this item 'Create a chart on a form or report'. Hopefully that will give you the answer you need. If so, please post back for the benefit of others

arnelgp · Aug 28, 2019

I have 2019 (cracked not retail) but I don't have that.
what is the Class name?

mine is MSGraph.Chart.8

isladogs · Aug 28, 2019

Maybe your cracked version is incomplete...
Can't answer your question as i'm not at the computer with A365.

The feature was added to Access just before A2019 was released.
See What's new in Access 2019
2 other links that may be useful https://www.youtube.com/watch?v=LW2Ct8Npyzs and https://answers.microsoft.com/en-us/msoffice/forum/msoffice_officeinsider-mso_win10-msoinsider_access/insiders-new-charts-in-access-to-help-you/3ff1ef18-d12c-4ac0-b298-ef09ffce8dad

The_Doc_Man · Aug 28, 2019

Are we talking manual adjustment of color or using VBA?

xyba · Aug 28, 2019

The_Doc_Man said:
Are we talking manual adjustment of color or using VBA?

Either method, I don't mind.

arnelgp · Aug 28, 2019

after much googling, finally found it (I hope):
on the Load event of your form, change the color of the data labels.
on VBA you may wish to select a ColorIndex or Color, press F2 and search ColorIndex.
change vbRed to whatever color you want.
change the graph name to your graph name.
the commented line also works if you want ColorIndex.

Code:

Private Sub Form_Load()
Dim s As Variant
For Each s In Me.Graph0.Object.Application.Chart.SeriesCollection
   With s
     '.DataLabels.Font.ColorIndex = 15
     .DataLabels.Font.Color = vbRed
   End With
Next

End Sub

isladogs · Aug 28, 2019

Hi
I haven't tested the code Arnel posted as I only saw his reply after checking out the modern chart property sheet in A365

Unlike the old or traditional' charts, you cannot click on items in a modern chart.
Instead you edit it using the Chart Settings tab and/or the Chart Property sheet

This includes several colour properties you can alter:

I couldn't find any method for changing the colour of the chart values.
Although you can change the label fontname & size, I couldn't see how to change the font style (bold/italic etc)

Hope that helps

Isskint · Jan 2, 2020

Happy New Year all!

Can anyone confirm if arnelgp's code worked? I have a similar requirement using the modern chart option, but that code does not work for me. I get Object doesnt support this property or method.

sonic8 · Jan 2, 2020

Isskint said:
Can anyone confirm if arnelgp's code worked? I have a similar requirement using the modern chart option, ...

arnelgp's code is for classic charts (MsGraph.Chart ActiveX) only.

If you are using Modern Charts, rather look at what Isladogs posted.

isladogs · Jan 2, 2020

It didn't work for me either (same error).
I tried using intellisense to do variations on that but never found a solution.
If you haven't already done so, have a read ofr the modern charts help article: https://support.office.com/en-gb/article/create-a-chart-on-a-form-or-report-1a463106-65d0-4dbb-9d66-4ecb737ea7f7
If its not covered there, you probably can't do it - ridiculous though that may seem.

However you could go back to using a traditional chart where it is definitely possible to change both colour and position of data labels

EDIT
Forgot to say that I spent some time playing with modern charts in the post https://www.access-programmers.co.uk/forums/showpost.php?p=1656830&postcount=4
It includes some code and an example app but I failed to change the data label colour using code or the interface

Graph Data Label Format (1 Viewer)

xyba

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

xyba

Registered User.

xyba

Registered User.

isladogs

MVP / VIP

Attachments

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

The_Doc_Man

Immoderate Moderator

xyba

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

Attachments

Isskint

Slowly Developing

sonic8

AWF VIP

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread