How to create Data labels on a stacked pivot chart in Access 2007

[F17RUK]

Hi,

i have a stacked pivot chart in access, i have WE date on the X axis and number of packages on Y, The pivot chart has been setup as showing count of the packages in a stacked form.

What i need to do is

Add data labels to all points on chart from start to end
change the data label properties to show the SERIES NAME only
Fill the data label box with colour "blue"
Add a border to data label


Change font to Universe 55 and size 10

and then remove the colour and border line from the normal series box, so only the Data label with the series with new format appear.

What would the code be for this? i am truly stuck :-(

[June7]

Review https://www.accessforums.net/showthr...ht=pivot+chart

There are a couple of links in that thread that might be helpful.

I really don't think can do much programmatically with pivot charts as they are not a graph control placed on a form or report that can be addressed with code.