Pie Charts & Pop Up Lists 1

[1DMF]

Hi,

I've been asked to create a Pie chart report, where each segment of the pie chart is clickable and displays the records in a list which make up that section of the pie chart.

All clicking on a report does, AFAIK , is zoom in with the magnifying glass.

Is this possible, And if so how?

Cheers,

1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[dhookom]

You might find this functionality in an Excel pivot chart (I'm not sure) but Access reports (at least prior to 2007) are static renderings.

Duane
Hook'D on Access
MS Access MVP

 

[1DMF]

thanks, didn't think it was possible.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!